StackIt allows business teams to pull data from SaaS tools & internal databases into spreadsheets in 1 click & refresh it automatically on hourly, weekly and monthly basis. 

A step-by-step guide on how to install and launch StackIt inside Google Sheets. Video link – https://youtu.be/kCGwm-Ix0eQ
Step 1: Simply Click on "Individual Install" on StackIt on Google Workspace Marketplace:
Step 2: Give necessary permissions
Step 3: Open a new or any existing Google Sheet then Click on Extensions, On the bottom of the Extensions menu you will find StackIt.

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

If you still don't find StackIt - Reach out to us on support@nowstackit.com

-----

Use Cases for internal databases & SQL based databases:
    * Sync MySQL to Google Sheets™️ 
- Build reports in Google Sheets™️ using your MySQL data.
- Write your own MySQL (SQL) queries.
- Import MySQL to Google Sheets. You can add your database connection credentials and write SQL queries within seconds!
- Use our Generative AI Natural Language to SQL engine (NL2SQL) to build powerful SQL queries using natural language

    * Sync PostgreSQL (Postgres) data to Google Sheets™️. 
- Build reports in Google Sheets™️ using your PostgreSQL data.
- Use our SQL editor to write your own PostgreSQL queries. .
- Import PostgreSQL to Google Sheets™️. You can add your database connection credentials and write SQL queries within seconds!

 * Sync Amazon Redshift to Google Sheets™️ 
- Build reports in Google Sheets™️ using your Amazon RedShift data.
- Write your own Amazon Redshift queries.
- Import Redshift to Google Sheets. You can add your database connection credentials and write SQL queries within seconds!


Use Cases for Revenue Ops:
    * Sync Chargebee data to Google Sheets™️. 
- Build reports in Google Sheets™️ using your Chargebee data.
- Use our Data Preview section to pick the right columns.
- Apply Filters to Slice and Dice chargebee data.
- Import Chargebee data to Google Sheets within seconds!

    * Sync HubSpot data to Google Sheets. 
- Build reports in Google Sheets using your HubSpot data.
- Use our Data Preview section to pick the right columns.
- Apply Filters to slice and dice HubSpot data.
- Import HubSpot data to Google Sheets within seconds!


Use Cases for Marketing Ads:
*Sync Linkedin Ads to Google Sheets™️*
- Pull live ads data from Linkedin Ads into Google Sheets
- Select visually the metrics you want to analyse
- Create Reports and dashboards directly on Google Sheets
- Update reports dynamically


---
1. 1-Click Imports: StackIt offers a hassle-free data import experience by allowing you to import data from pre-built integrations with just one click. This feature is especially useful for business teams that need to work with large datasets quickly and efficiently. With StackIt, you can say goodbye to the time-consuming process of manually copying and pasting data from various sources.

2. Live Data Preview Section before Importing Data: StackIt'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.

3. Automatic Data Imports: One of StackIt's most convenient features is the ability to schedule automatic data imports. This means that you can configure StackIt 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 analyzing and interpreting data, instead of spending hours on manual data entry.

4. Integration Specific Recipes: StackIt offers pre-built integrations with popular SaaS tools and databases. Integration specific recipes are tailor-made for specific data sources, providing quick and easy access to data without the need for complex coding or database queries. This feature is especially useful for non-technical users who need to work with data but lack programming skills. StackIt's pre-built integrations make it easy to work with data, without requiring any special knowledge or expertise.

5. Team Specific Recipes per Integration: StackIt 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.

6. Smart Column Pairing: StackIt'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 StackIt, you can say goodbye to the time-consuming process of VLOOKUPS and other manual data matching processes.

7. No-Code Visual Query Builder: StackIt's no-code visual query builder provides an intuitive and user-friendly way to create complex queries without writing any code. This feature is especially useful for non-technical users who need to work with data but lack programming skills. The visual query builder makes it easy to create advanced queries, without requiring any special knowledge or expertise.

8. Import via Custom SQL: StackIt allows you to import data using custom SQL queries, providing you with the flexibility to pull any data directly from SQL queries repeatedly. This feature is especially useful for technical users who are comfortable working with SQL queries. Importing data using custom SQL queries provides a powerful and flexible way to work with data, enabling you to create complex reports and analyses.

9. Filter / Sort Data before Imports: StackIt 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.

10. No Code SQL Joins (Data Correlation): StackIt enables you to join data from different sources using SQL joins without writing any code. You can easily correlate data from different sources such as SaaS tools and databases to create more complex reports and analyses. This feature simplifies the process of combining data from various sources, saving you time and effort. With StackIt's no-code SQL joins, you can easily generate insights from multiple datasets and gain a more comprehensive understanding of your business performance.

11. Custom Alerts on third party tools: With StackIt, 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 customize 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 StackIt's custom alerts, you can stay on top of your business and make informed decisions that impact your bottom line.

12. Pre-built Dashboards: StackIt offers pre-built dashboards that allow you to visualize 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 customize the dashboards to suit your specific needs. By using StackIt's pre-built dashboards, you can save time on data visualization and focus on analyzing the data to gain insights.

13. Role Based Access Control: StackIt 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 authorized 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 StackIt's role-based access control, you can enforce data security and ensure compliance with data protection regulations.

14. Create teams & co-workers: StackIt 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 function or project 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 StackIt's team collaboration features, you can streamline data sharing, improve communication, and enhance productivity.

15. Shared Connections: StackIt 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 StackIt's shared connections, you can ensure that your team has access to up-to-date data and can collaborate effectively.

16. Review – Maker/Checker: StackIt provides a review feature that allows you to assign a maker/checker workflow to ensure data accuracy and completeness. This feature is particularly useful in cases where data is being entered or edited by multiple individuals. With StackIt's review feature, you can easily assign different roles to different users, allowing them to perform different tasks based on their level of expertise.

StackIt is designed to be a versatile platform that can accommodate a wide range of data sources and integrations. As of now, it supports four popular integrations: HubSpot, Chargebee, PostgreSQL (Postgres), and MySQL, Amazon Redshift and LinkedIn Ads.

Chargebee is a subscription management platform that provides a complete set of tools for managing recurring billing, payments, and subscriptions. With StackIt's integration with Chargebee, you can easily pull data on customer subscriptions, invoices, and payments to gain insights into your business's financial health.

PostgreSQL is a powerful open-source relational database management system that is widely used for data warehousing, web applications, and analytics. With StackIt's integration with PostgreSQL, you can easily connect to your PostgreSQL database and query data to create reports and analyses.

Integrations coming soon:
Web Analytics Tools: Google Analytics, Mixpanel, Heap, Segment.
Performance Marketing Tools: Google Ads, Facebook Ads, Apple Search Ads, LinkedIn Ads, Microsoft Advertising, Google Ad Manager (GAM), Adwords.
SEO, SEM, and PPC Tools: SEMRush, AHrefs, Moz, Google Search Console, Bing Services, Yandex.
Ecommerce Platforms: Shopify, WooCommerce, Amazon PPC, Dukaan
Email Marketing Tools: MailChimp, SendGrid, MailGun, Twilio, Outreach, Klaviyo.
Project Management Tools: Asana, Trello, Jira, Airtable, GitHub
Payment Platform Tools: Stripe, PayPal, Razorpay 
CRMs: Salesforce, Wordpress, Zendesk, Pipedrive, Weebly, Salesloft.
Database Systems: Google BigQuery & Data Studio, SQL, RDS, AWS, MongoDB, Redshift, Snowflake.
Accounting and Tax Platforms: Quickbooks, Xero, Freshbooks, Tally.
Productivity and Business Tools: Pipedrive, Slack, Zoho, Dropbox.

If you've experienced limitations with tools like Zapier, Coefficient, Coupler, G-Connector for Salesforce, Xappex, API Pipeline, KPIBees, or Sheetgo, StackIt is the way to go! 

MySQL is another popular open-source relational database management system that is widely used for web applications and e-commerce platforms. With StackIt's integration with MySQL, you can easily extract data from your MySQL database to create reports and gain insights into your business's performance.

HubSpot is a comprehensive inbound marketing, sales, and customer service platform that helps businesses attract, engage, and delight customers.

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. So, stay tuned for updates as we continue to expand our integration offerings.