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