Sheet Director add-on helps to manage and control bi-directional data flow between Google Sheetsâą and from G Suite, CRM, Accounting, Productivity, Marketing, Payment, Time Tracking, Ticketing, Social, etc apps. Sheet Director supports 45+ apps across various categories. KEY FEATURES âș Manage Services: You can manage multiple services from a single Google Sheetsâą that connects to several Apps. These services can be listed, edited, executed, and deleted. âș Connect with Apps through various authentication mechanisms (key, oAuth1, oAuth2, etc). âș Bi-directional data flow - Query (pull), Post (push) and Synchronize (sync) service types âș Query Apps to pull data and present results into Google Sheetsâą âș Comprehensive Query features - field selection, custom filters, sorting, limit results, etc. âș Choose or create the destination sheet and configuration for managing destinations âș Prepare and Post data from Google Sheetsâą into Apps âș Conditional Posting - Post your records to Apps when it meets your custom conditions âș Keep your records synced in both the Apps and Google Sheetsâą âș Manual and automatic (scheduled) execution of services - Set monthly, weekly, daily, or hourly refreshes and automate your services. âș Success notification with a templated email message âș Error/warning notification is sent when there is a failure in processing the configured services. âș Execution Logs to monitor automated executions âș Rich AI Functions to make your Google Sheetsâą Intelligent âș Excellent connection management - reuse your connection multiple times on different services âș Custom Functions - Invoke your service directly from the Google Sheetsâą cell formula without opening the addon. Automate your day-to-day reporting with an awesome dashboard, and visualizations from cross-platform/app data mashups. Sheet Director is a great API Connector and integrator, and it is the best alternative to and complement Zapier, Supermetrics, Automate.io, Workato, Make.com, SheetsGo, JSON Importer, etc. APPLICATIONS AND SERVICES Below are the applications supported along with the services offered. Remember that there is no limit to your creativity in using Sheet Director wherever you feel it fits and whatever use cases you may have. Ö Productivity Apps to Google Sheetsâą: âș Asana to Google Sheetsâą â„ Query - Pull data from Asana objects and store it in a spreadsheet. â„ Post - Post data from Google Sheetsâą into Asana objects. â„ Sync - Sync data with Google Sheetsâą into Asana objects. âș Trello to Google Sheetsâą â„ Query - Pull data from Trello objects and store it in a spreadsheet. â„ Post - Post data from Google Sheetsâą into Trello objects. â„ Sync - Sync data with Google Sheetsâą and Trello objects. âș Airtable to Google Sheetsâą â„ Query - Pull data from Airtable objects and store it in a spreadsheet. â„ Post - Post data from Google Sheetsâą to Airtable. â„ Sync - Sync data with Google Sheetsâą and Airtable. âș Smartsheet to Google Sheetsâą â„ Query - Pull data from Smartsheet and present it into Google Sheetsâą. â„ Post - Post data from Google Sheetsâą into Smartsheet. â„ Sync - Sync data with Google Sheetsâą and Smartsheet. Ö Inventory Management Apps to Google Sheetsâą: âș Cin7 Omni to Google Sheetsâą â„ Query - Pull data from Omni entities and store it in a spreadsheet, â„ Post - Post data into Omni â„ Synchronise - Sync the data from Google Sheetsâą to Omni. âș Cin7 Core to Google Sheetsâą â„ Query - Pull data from Core entities and store it in a spreadsheet, â„ Post - Post data into Core â„ Synchronise - Sync the data from Google Sheetsâą to Core. Ö Google Workspace Apps to Google Sheetsâą: âș Google Sheetsâą â„ Distribute - Segment data from a source sheet and send that data across the 'n' number of sheets based on configuration. â„ Backup - Back up Google Sheetsâą by cloning/ copying into the folder. â„ Backup Tab - Back up the Google Sheetsâą tab by cloning/ copying it into the preset Google Sheetsâą â„ Consolidate - Combine data from multiple spreadsheets into a single Google Sheetsâą â„Automate - Automate your Google Sheetsâą actions and perform any operations automatically on Google Sheets Changes âș Email â„ Send Email - Send contents from Google Sheetsâą as PDF and Inline table to the client via Email. â„ Mail Merge - Send emails by merging data from Google Sheetsâą with a templated email message âș Google Driveâą to Google Sheetsâą â„ List File -Select a folder from Google Driveâą and list all files in it inside a Google Sheetsâą. âș Google Calendarâą to Google Sheetsâą â„ Get Events - Query and pull calendar events from Google Calendarâą into Google Sheetsâą. â„ Post Events - Post Google Sheetsâą data into Google Calendarâąto create Google Calendarâąevents. â„ Sync Events - Sync Google Sheetsâą data with Google Calendarâą events âș Google Tasksâą to Google Sheetsâą â„ Get Tasks - Pull all tasks from Google Tasksâą and present them in Google Sheetsâą. â„ Post Tasks - Post data from Google Sheetsâą to Google Tasksâą âș Google Contactsâą to Google Sheetsâą â„ Get Contacts - Pull all contacts from Google Contactsâą into Google Sheetsâą. â„ Post Contacts - Push data from Google Sheetsâą into Google Contactsâą. â„ Sync Contacts - Sync data with Google Sheetsâą and Google Contactsâą. âș Google Classroomâą to Google Sheetsâą â„ Query - Query all contents from Google Classroomâą and present it in Google Sheetsâą. âș Google Adminâą to Google Sheetsâą â„ Query - Query all contents from Google Adminâą and present it in Google Sheetsâą. â„ Post- Push data from Google Sheetsâą into Google Adminâą Objects. â„ Sync - Sync data with Google Sheetsâą and Google Adminâą. âș Google Analyticsâą to Google Sheetsâą â„ Query - Query all contents from Google Analyticsâą and present it in Google Sheetsâą. Ö Google Apps to Google Sheetsâą: âș Google My Businessâą to Google Sheetsâą â„ Query - Query data from Google My Businessâą and present it in Google Sheetsâą. âș Youtube to Google Sheetsâą â„ Query - Query data from YouTube and present it in Google Sheetsâą. âș YouTube Analytics to Google Sheetsâą â„ Query - Query data from Youtube Analytics and present it in Google Sheetsâą. Ö Accounting Systems to Google Sheetsâą: âș QuickBooks to Google Sheetsâą â„ Query - Pull data from QuickBooks entities & reports and present it into Google Sheetsâą. â„ Post - Push data from Google Sheetsâą to QuickBooks entities â„ Sync - Sync data with Google Sheetsâą and QuickBooks entities âș FreshBooks to Google Sheetsâą â„ Query - Pull data from FreshBooks and present it into Google Sheetsâą. â„ Post - Push data from Google Sheetsâą to FreshBooks. â„ Sync - Sync data with Google Sheetsâą to FreshBooks. âș Xero to Google Sheetsâą â„ Query - Pull data from Xero and present it into Google Sheetsâą. â„ Post - Push data from Google Sheetsâą to Xero â„ Sync - Sync data with Google Sheetsâą and Xero âș Zoho Books to Google Sheetsâą â„ Query - Pull data from Zoho Books objects like invoices, and expenses and present it into Google Sheetsâą. â„ Post - Push data from Google Sheetsâą to Zoho Books objects. â„ Sync - Sync data with Google Sheetsâą and Zoho Books objects. âș Zoho Invoice to Google Sheetsâą â„ Query - Pull data from Zoho invoice objects like contacts, and invoices and present it into Google Sheetsâą. â„ Post - Push data from Google Sheetsâą to Zoho invoice objects. â„ Sync- Sync data with Google Sheetsâą and Zoho invoice objects. âș Zoho Expense to Google Sheetsâą â„ Query - Pull data from Zoho Expenses objects like contacts, and expenses and present it into Google Sheetsâą. â„ Post - Push data from Google Sheetsâą to Zoho Expenseobjects. â„ Sync- Sync data with Google Sheetsâą and Zoho Expense objects. âș Wave to Google Sheetsâą â„ Query - Pull all the data from Wave objects and store it in a Spreadsheet â„ Post - Push the data from Google Sheetsâą into Wave â„ Sync- Sync data with Google Sheetsâą and Wave. Ö CRM Systems to Google Sheetsâą: âș Hubspot to Google Sheetsâą â„ Query - Pull data from HubSpot objects and present it in a Spreadsheet. â„ Post - Push data from the spreadsheet to HubSpot. â„ Sync- Sync data with the spreadsheet and HubSpot. âș Salesforce to Google Sheetsâą â„ Query - Pull all contacts from Salesforce objects and store them in a spreadsheet. â„ Post - Push all contacts from spreadsheet to Salesforce. â„ Sync- Sync data with the spreadsheet and Salesforce. âș Insightly to Google Sheetsâą â„ Query - Pull data from Insightly objects and store it in a spreadsheet. â„ Post - Push data from the spreadsheet to Insightly. â„ Sync- Sync data with the spreadsheet and Insightly. âș Copper to Google Sheetsâą â„ Query - Pull data from Copper objects and store it in a spreadsheet. â„ Post - Push data from the spreadsheet to Copper. â„ Sync- Sync data with the spreadsheet and Copper. âș Capsule to Google Sheetsâą â„ Query - Pull data from Capsule objects and store it in a spreadsheet. â„ Post - Push data from spreadsheet to Capsule. â„ Sync- Sync data with the spreadsheet and Capsule. âș EngageBay to Google Sheetsâą â„ Query - Pull data from EngageBay objects and store it in a spreadsheet. â„ Post - Push data from the spreadsheet to EngageBay. â„ Sync- Sync data with the spreadsheet and EngageBay. âș Zoho CRM to Google Sheetsâą â„ Query - Pull data from Zoho CRM objects and store it in a spreadsheet. â„ Post - Push data from the spreadsheet to Zoho CRM. â„ Sync- Sync data with the spreadsheet and Zoho CRM. âș Agile CRM to Google Sheetsâą â„ Query - Pull data from Agile CRM objects and store it in a Google Sheetsâą â„ Post - Push data from Google Sheetsâą to Agile CRM. â„ Sync- Sync data with the Google Sheetsâą and Agile CRM. âș Vtiger CRM to Google Sheets â„ Query - Pull data from Vtiger CRM objects and store it in a Google Sheetsâą â„ Post - Push data from Google Sheetsâą to VTiger CRM. â„ Sync- Sync data with the Google Sheetsâą and VTiger CRM. âș Pipedrive to Google Sheets â„ Query - Pull data from Pipedrive objects and store it in a Google Sheetsâą â„ Post - Push data from Google Sheetsâą to Pipedrive. â„ Sync- Sync data with the Google Sheetsâą and Pipedrive. âș Freshsales Suite to Google Sheets â„ Query - Pull data from Freshsales Suite objects and store it in a Google Sheetsâą â„ Post - Push data from Google Sheetsâą to Freshsales Suite. â„ Sync- Sync data with the Google Sheetsâą and Freshsales Suite. âș Firmao Suite to Google Sheets â„ Query - Pull data from Firmao objects and store it in a Google Sheetsâą â„ Post - Push data from Google Sheetsâą to Firmao. â„ Sync- Sync data with the Google Sheetsâą and Firmao. âș Zoho Bigin to Google Sheets â„ Query - Pull data from Zoho Bigin objects and store it in a Google Sheetsâą â„ Post - Push data from Google Sheetsâą to Zoho Bigin. â„ Sync- Sync data with the Google Sheetsâą and Zoho Bigin. Ö Payment Apps to Google Sheetsâą: âș PayPal to Google Sheetsâą â„ Query - Pull data from PayPal objects and store it in a spreadsheet. âș Stripe to Google Sheetsâą â„ Query - Pull data from Stripe objects and store it in a spreadsheet. Ö Time tracking Apps to Google Sheetsâą: âș Clockify to Google Sheetsâą â„ Query - Pull data from Clockify objects and store it in a spreadsheet. â„ Post - Push data from Google Sheetsâą to Clockify. â„ Sync- Sync data with the Google Sheetsâą and Clockify. âș Harvest to Google Sheetsâą â„ Query - Pull data from Harvest objects and store it in a spreadsheet. â„ Post - Push data from Google Sheetsâą to Harvest. â„ Sync- Sync data with the Google Sheetsâą and Harvest. âș Toggl to Google Sheetsâą â„ Query - Pull data from Toggl objects and store it in a spreadsheet. â„ Post - Push data from Google Sheetsâą to Toggl. â„ Sync- Sync data with the Google Sheetsâą and Toggl. âș Hubstaff to Google Sheetsâą â„ Query - Pull data from Hubstaff objects and store it in a spreadsheet. â„ Post - Push data from Google Sheetsâą to Hubstaff. â„ Sync- Sync data with the Google Sheetsâą and Hubstaff. Ö Marketing Apps to Google Sheetsâą: âș Mailchimp to Google Sheetsâą â„ List Members - Pull data from Mailchimp objects and store it in a spreadsheet. â„ Post - Push data from spreadsheet to Mailchimp.EngageBay to Google Sheetsâą âș Active Campaign â„ Query - Pull data from ActiveCampaign objects and store it in a spreadsheet. â„ Post - Push data from the spreadsheet to ActiveCampaign. âș Get Response to Google Sheetsâą â„ Query - Pull data from GetResponse objects and store it in a spreadsheet. â„ Post - Push data from the spreadsheet to GetResponse. âș Drip to Google Sheetsâą â„ Query - Pull data from GetResponse objects and store it in a spreadsheet. â„ Post - Push data from the spreadsheet to GetResponse. âș Reply.io to Google Sheetsâą â„ Query - Pull data from Reply.io objects and store it in a spreadsheet. â„ Post - Push data from the spreadsheet to Reply.io. â„ Sync- Sync data with the Google Sheetsâą and Reply.io. Ö Ticketing Apps to Google Sheetsâą: âș Zendesk to Google Sheetsâą â„ Query - Pull data from Zendesk objects and store it in a spreadsheet. âș Freshdesk to Google Sheetsâą â„ Query - Pull data from Freshdesk objects and store it in a spreadsheet. âș JIRA to Google Sheetsâą â„ Query - Pull data from JIRA entities and store it in a spreadsheet. â„ Post - Push data from Google Sheetsâą to JIRA. â„ Sync- Sync data with the Google Sheetsâą and JIRA. âș Zoho Desk to Google Sheetsâą â„ Query - Pull data from Zoho Desk objects and store it in a Google Sheetaâą Ö Shipping Apps to Google Sheetsâą: âș ShipStation to Google Sheetsâą â„ Query into Sheet - Pull data from Shipstation entities and store it into a spreadsheet. Ö Project Management Apps to Google Sheetsâą: âș Zoho Projects to Google Sheetsâą â„ Query - Pull data from Zoho Projects entities and store it in a spreadsheet. âș Zoho Bugtracker to Google Sheetsâą â„ Query - Pull data from Zoho Bugtracker entities and store it in a spreadsheet. âș Zoho Subscriptions to Google Sheetsâą â„ Query - Pull data from Zoho Subscriptions objects and store it in a spreadsheet. Zoho Creator to Google Sheetsâą âș Query - Pull data from Zoho Creator objects and store it in a spreadsheet. â„ Post - Push data from Google Sheetsâą to Zoho Creator. â„ Sync- Sync data with the Google Sheetsâą and Zoho Creator. Ö Databases to Google Sheetsâą: âș Databases like Oracle, MySql, MS SQL Server, MongoDB, Redshift, DynamoDB, Snowflake to Google Sheetsâą. â„ Query - Pull data from databases and store it in a spreadsheet, â„ Post records to the database. â„ Synchronise the records with the database. SUPPORT For more details refer to https://sheetdirector.jivrus.com/ Contact us at https://www.jivrus.com/about/contact-us or email support@jivrus.com for any query or feature request. Check all our products at https://www.jivrus.com/products