With AI & GPT Functions. Pull data from Hubspot, Salesforce, Shopify, Facebook, Google Adword, Stripe, Asana, Monday, Notion, Shiprocket & more.
Listing updated:July 16, 2024
Works with:
6K+
Overview
API Connector for Sheets allows users to connect Google Sheets with any REST API or GraphQL API in a flexible and user-friendly manner. 

This empowers teams to pull data from all platforms, including Stripe, Zoho, Salesforce, Outreach, MailChimp, SendGrid, Twilio, BigQuery™, PostgreSQL, MySQL, Microsoft SQL Server, Snowflake, Asana, Trello, Jira, Airtable, Chargebee, Recurly and more, providing the freedom to pull data based on specific business requirements. It is tailored for revenue operations managers and data-driven teams.

The data connector seamlessly connects with Facebook Ads, Shopify, Salesforce, HubSpot, Google Analytics™, Google Ads™, Notion, databases, Chargebee, Mixpanel, Heap Segment and more.

-----------------------------------------------------------------------------------------------------------------------

🧰Ideal Use Cases : 
✅Sales and Marketing Analytics: Integrate customer interaction data from custom CRMs [Salesforce, Zoominfo, Outreach, Hubspot, Zoho] or bespoke e-commerce platforms to analyse customer behaviour and sales trends.
✅Financial Reporting: Integrate financial reporting data from financial APIs or tools [Stripe, Razorpay, Tally, Quickbooks, Xero, Freshbooks] to pull real-time budget, expenditure, and revenue data.
✅Operational Efficiency: Automate the import of logistical data, inventory levels, and supply chain information for seamless operational oversight.


-----------------------------------------------------------------------------------------------------------------------

🧰Possible Integrations ideas :

✅Web Analytics Tools : Pull data from Google Analytics, Mixpanel, Heap, Segment, Adobe Analytics, Hotjar to Google Sheets
✅Performance Marketing Tools: Pull data from Google Ads, Facebook Ads, Apple Search Ads, LinkedIn Ads, Microsoft Advertising, Google Ad Manager (GAM), Adwords, TikTok Ads, Twitter Ads, Snapchat Ads, Pinterest Ads, AdRoll to Google Sheets
✅SEO, SEM, and PPC Tools: Pull data from SemRush, Google Search Console, Bing Services.
Ecommerce Platforms: Connect with Shopify, WooCommerce, Amazon PPC, Dukaan, BigCommerce, Magento to Google Sheets.
✅Email Marketing Tools: Pull data from MailChimp, SendGrid, MailGun, Twilio, Outreach, Klaviyo, HubSpot to Google Sheets.
✅Project Management Tools: Pull data from Asana, Trello, Jira, Airtable, GitHub, Monday.com, Basecamp, ClickUp, Notion to Google Sheets. 
✅Payment Platform Tools: Pull data from Stripe, PayPal, Razorpay, Square to Google sheets.
✅CRMs: Pull data from Salesforce, Wordpress, Zendesk, Pipedrive, Weebly, Salesloft, HubSpot CRM, Zoho CRM, Microsoft Dynamics 365 to Google Sheets.
✅Database Systems: Pull data from Google BigQuery & Data Studio, SQL, RDS, AWS, MongoDB, Redshift, Snowflake, PostgreSQL, Cassandra, Firebase, Oracle to Google Sheets.
✅Accounting and Tax Platforms: Pull data from Quickbooks, Xero, Freshbooks, Tally, Wave, Zoho Books, NetSuite to Google Sheets.
✅Productivity and Business Tools: Pull data from Pipedrive, Slack, Zoho, Dropbox, Google Workspace (formerly G Suite), Microsoft Office 365, Evernote, Miro, Todoist to Google Sheets.


-----------------------------------------------------------------------------------------------------------------------
🧰Features : 

✅1-Click Imports: Easily import data from any custom Rest or GraphQL API into Google Sheets™️ with a single click, saving time and reducing errors. This feature is especially useful for business, finance, marketing, customer success and rev-ops teams that need to work with large datasets quickly and efficiently. With Superjoin (previously Stackit), you can say goodbye to the time-consuming process of manually copying and pasting data from various sources.


✅ Live Data Preview Section before Importing data: Superjoin's live data preview section provides a seamless way to preview the data before importing it into Google Sheets™️. This section offers an opportunity to ensure that the data you are pulling is correct and to avoid any mistakes that may arise due to incorrect data inputs. The live data preview section also enables you to identify and fix any issues before you import the data into Google Sheets™️, ensuring accuracy and reducing errors.


✅ Automatic Data Imports: One of Superjoin's most convenient features is the ability to schedule automatic data imports. This means that you can configure Superjoin to import data automatically at regular intervals, such as daily, weekly, or monthly. This feature saves time and effort, ensuring that your data is always up to date without manual intervention. Automatic data imports also allow teams to focus on more strategic tasks, such as analysing and interpreting data, instead of spending hours on manual data entry.


✅Custom API Connection: Superjoin allows you to connect to any API, including Stripe, Recurly, OpsIQ, Hubspot and more without hassle, allowing for flexible data integration tailored to your specific business needs.


✅Team Specific Recipes per Integration: Superjoin allows you to create team-specific recipes for each integration, making it easy for team members to access the data they need without relying on others. This feature enables team members to work more collaboratively, allowing them to share data and insights seamlessly. Team-specific recipes also reduce the risk of errors and miscommunications, ensuring that everyone is working with the same data.


✅Smart Column Pairing: Superjoin's smart column pairing feature is designed to save you time and effort by automatically pairing columns based on data that doesn't make sense without the other column. This feature eliminates the need for manual matching of columns, reducing the risk of errors and inconsistencies. With Superjoin, you can say goodbye to the time-consuming process of VLOOKUPS and other manual data matching processes.


✅Filter / Sort Data before Imports: Superjoin allows you to filter and sort data before importing it, right from the preview section. This feature ensures that you only pull the data you need, saving time and reducing errors. Filtering and sorting data also make it easier to work with large datasets, allowing you to focus on the most relevant data points.


✅Custom Alerts on third party tools: With Superjoin, you can set up custom alerts based on data from third-party tools. This feature ensures that you are always aware of critical events and can take timely action when necessary. You can customise alerts based on specific data points and set up notifications via email or Slack. This way, you can quickly respond to important events such as a customer reaching a specific usage threshold, a payment failure, or a significant change in your website traffic. By leveraging Superjoin's custom alerts, you can stay on top of your business and make informed decisions that impact your bottom line.


✅Pre-built Dashboards: Superjoin offers pre-built dashboards that allow you to visualise your data quickly and easily. These dashboards come with pre-configured charts, graphs, and tables that display key metrics and KPIs relevant to your business. This feature makes it easy to spot trends, identify insights, and communicate data-driven insights to your team. Additionally, you can customise the dashboards to suit your specific needs. By using Superjoin's pre-built dashboards, you can save time on data visualisation and focus on analysing the data to gain insights.


✅Role Based Access Control: Superjoin provides role-based access control that allows you to control who has access to specific data and features. This feature ensures that your data is secure and accessible only to authorised users. You can create roles and assign permissions based on job function or department. For instance, you can give your sales team access to data related to leads and prospects, while restricting access to financial data. With Superjoin's role-based access control, you can enforce data security and ensure compliance with data protection regulations.


✅Create teams & co-workers: Superjoin allows you to create teams and add co-workers, which makes it easy to collaborate and share data. This feature ensures that your team members can access the data they need to make informed decisions. You can create teams based on job functions or projects and invite co-workers to join. Additionally, you can assign roles and permissions to ensure that team members can access only the data they need. With Superjoin's team collaboration features, you can streamline data sharing, improve communication, and enhance productivity.


✅Shared Connections: Superjoin enables you to share connections between team members. This feature ensures that team members can access and use the same data sources. You can create shared connections for different data sources such as SaaS tools and databases, and grant access to team members based on roles and permissions. This feature saves time and ensures data consistency by avoiding duplication of efforts. With Superjoin's shared connections, you can ensure that your team has access to up-to-date data and can collaborate effectively.

If you've experienced limitations with tools like “Zapier for Google Chat”, “Api Connector”, “Coefficient : Salesforce, Hubspot Data Connector”, “Data Connector : JSON API OAUTH FREE”, “Castodia Data Connector”, “Conduit App - Data Connector for Sheets”, “Porter Marketing Data Connector to Google Sheets”, “Uniquery : Facebook, Shopify, Notion Data Connector”, “Data connector for Adobe Analytics”, “Simplemetrics Data Connector for Google Trends™ & Google Sheets™” , “Amigo : Shopify, Salesforce, Hubspot Data Connector”,  “Apipheny - API Connector”, “Rest | API Connector”, Scalemetric, Coupler, “Uniquery : Facebook, Shopify, Notion Data Connector”, “Supermetrics”, “Phlorin - API Connector to import data into Sheets”, “Catchr - Data Connector, “G-Connector for Salesforce”, Xappex, API Pipeline, KPIBees, or Sheetgo, Superjoin is the way to go! 

-----------------------------------------------------------------------------------------------------------------------

Feature Most loved : 
1-Click Connections: Connect to your systems in one click. Pull your data instantly into Google Sheets™. Sync with systems like Salesforce, Looker™, Snowflake, Redshift, Google Analytics™, HubSpot, MySQL, PostgreSQL, MS SQL Server, Chargebee, Notion, and other Google Sheets™. Connect to any objects or reports to pull data into Google Sheets™ in a few clicks. Take advantage of 2-way sync capabilities for Salesforce, HubSpot, Snowflake, PostgreSQL, MySQL, and more.


🧰Benefits
✅Boost Productivity: Automate data imports and updates to focus on more critical tasks, enhancing overall productivity.
✅Enhance Accuracy: Reduce manual entry errors by automating data retrieval, leading to more accurate and reliable data.
✅Streamline Workflows: Simplify your data management processes with seamless API connections and automatic updates.
✅Flexibility & Scalability: Adapt to your business's changing needs with custom API connections, supporting various data sources and applications.

-----------------------------------------------------------------------------------------------------------------------

🧰How does it work?


✅Identify the API: Choose the rest or graphql API you need to connect with your Google Sheets.
✅Configure the Connection: Use Superjoin to set the API endpoints and define the data structure.
✅Customise Data Handling: Apply filters and set up data transformation rules as per your business logic.
✅Automate Refreshes: Schedule how often your data should be updated, ensuring your reports always reflect the most current data.


If you have tried tools like Zapier, “Coefficient : Salesforce, Hubspot Data connector”, Apipheny, Rest | Api Connector, Scalemetric, Coupler, Uniquery, Supermetrics, Phlorin, “Castodia Data Connector”, “Data Connector - JSON Api Oauth Free”, “Conduit.app - Data Connector for Sheets”, or KPIBees and unable to solve for your use case, don’t worry. You will love Superjoin. 

-----------------------------------------------------------------------------------------------------------------------


🧰How to install?
A step-by-step guide on how to install and launch Superjoin inside Google Sheets. Video link  https://www.youtube.com/watch?v=mD8mc30kBXY
✅ Simply Click on "Individual Install" on Superjoin on Google Workspace Marketplace:
✅ Give necessary permissions
✅Open a new or any existing Google Sheet then Click on Extensions, On the bottom of the Extensions menu you will find Superjoin.


*Note: In case you don't find Superjoin under Extensions, please reload the spreadsheet, and wait for 20-30 seconds. 


If you still don't find Superjoin - Reach out to us on support@superjoin.ai


We understand that businesses use a variety of tools and platforms, and we want to make it as easy as possible for you to access all of your data in one place. And this tool allowed you to do just that. We hope you like it, the way we do. 


Welcome onboard!
Additional information
PricingFree of charge trial
Privacy policy
Terms of service
API Connector (with AI & GPT) | REST & GraphQL will ask for the permissions shown below. Learn more
API Connector (with AI & GPT) | REST & GraphQL will need access to your Google account
This will allow API Connector (with AI & GPT) | REST & GraphQL to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Tabassum Hasan
July 1, 2024
I am already loving this tool. I have used API Connector to pull data from Facebook Ads and track project timelines from Asana. I think it’s very efficient and has improved my productivity immensely. The only issue was that it was difficult for me to understand the interface as a first-time user but once I understood it, it became so easy. The automation features are just great. Overall it's a great product, thank you so much.
Is this review helpful?
Yes
No
Profile Picture
Vinayak J
June 20, 2024
My personal use of the Superjoin API Connector involves creating unique, self-updating monitoring tools. It bridges the gap between REST APIs and user-friendly data visualization. When used with Google Data Studio, it unlocks countless possibilities with a minimal and efficient toolchain. The API Connector is reliable, glitch-free, and ready for production. Pro tip: if you ever get stuck, the support team is exceptional!
Is this review helpful?
Yes
No
Profile Picture
Aviral Jain
June 24, 2024
The API Connector allows us to transfer and organise data between different platforms effortlessly. Its advanced mapping capabilities and responsive support team make it a reliable tool. It's become an essential part of my daily workflow. It has already amplified my team's impact by enabling me to automate alerts to our Slack workspace.
Is this review helpful?
Yes
No
Profile Picture
Tanmay
June 25, 2024
I lead a team at a small D2C startup (Delfa). API Connector has already boosted my team's workflows and eliminated pointless steps. We no longer have to deal with manual updates, and our reports are always up-to-date. The automatic refresh feature is simply fantastic. It is really a game changer. A must try!
Is this review helpful?
Yes
No
Profile Picture
Soumya Ranjan Dash
June 3, 2024
My boss asked me to check this out and It is truly an incredible data connector. It saves me so much time. It has made setting up automated dashboards in Google Sheets super easy. By having a reliable link to the data source, primarily Chargebee and Stripe, I don't have to worry about exporting or updating static files, and the team can focus on using the data instead of moving it. Would 100% recommend it.
Is this review helpful?
Yes
No
Profile Picture
Karan Dua
May 28, 2024
This is the exact solution that I have been looking for several weeks now. Tried several tools to integrate different sources to Google Sheets, especially Jira and Asana. I tried Pabbly and other data connectors but nothing was working for me. This is by far the most capable and user friendly product, and integrates well with Jira. What used to take hours and was error-prone is now automated and error-free. Tons of useful features as well. Good Product!!
Is this review helpful?
Yes
No
Profile Picture
Gourav Kohli
May 22, 2024
Useful - 5/5 Interface - 4.5/5 Customer Support - 10/5 First - This tool is exceptionally well built, intuitive, and reliable. If you are new to APIs connector, you can get a basic connection up and running quickly. My first connection was up in less than 30 minutes including install time. Second - What I really loved was the ability to preview the data before importing it to Google Sheets. This helped me understand what to expect and also made the modification before importing. I loved this feature. Very interesting. Third - One common problem with google sheets is getting lost in the mountain of multiple sheets. What I really love is the library section, which collects all google sheets in one place. Fourth - Lastly, I really love the pre-built templates. The dashboard allowed my team to connect data sources and get the dashboard running instantly. Yes, I had to customise them, but it was a good starting point. I really like it. I have all sorts of systems to pull data from, Stackit api connector is really helpful. Thanks again, Stack It!
Is this review helpful?
Yes
No
Profile Picture
srikar sarathy
May 29, 2024
Internally, we use a variety of tools to track work and progress & also to create reports for clients. As a small marketing agency owner, who needs to track several of these tools, analyse trends and offer new insights to my team and clineys, I end up doing a lot of the integration in Google Sheets bringing data from several external sources. This Api connector has helped me bring data from Twitter Ads, Youtube Analytics, Google Analytics and few other sources, import them and set a schedule for receiving updates. I then use information from those imports and match them together to get a bigger picture. I've created my own High level dashboards that instantly give me a big picture view, from several data sources. All in all, the product is saving me a lot of time and is super helpful. ~Srikar
Is this review helpful?
Yes
No
Profile Picture
Himanshu Kalra
June 25, 2024
This is such a useful product. Please do try it Asap. I have to create weekly reports and need to pull data from hubspot and salesforce. This works way better than other connectors. What I like is it's good UI, automatic refresh functionality and library section….This is the best tool in Google Sheet environment so far. I am also thinking of integrating with other tools. I just hope it works the same. A great tool. Loved it. Keep up the good work.
Is this review helpful?
Yes
No
Profile Picture
Ojas Tyagi
May 31, 2024
The product is good.Very well thought and developed. We use it in our company to track our product data (with PostgreSQL database) in Google Sheets. Since we are in the early stage, we cannot afford a CRM. Also want to keep it simple as of now. Moving to a mixpanel or amplitude doesn’t make sense. Plus anyway, we need to bring data to GSheet anyway to crunch the numbers, where this tool is very helpful.
Is this review helpful?
Yes
No
1-10 of 47
Search
Clear search
Close search
Google apps
Main menu