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 - manage multiple services from single Google Sheet connecting 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) and Post (push) service types ► Query Apps to pull data and present results into Google Sheet ► Comprehensive Query features - field selection, custom filters, sorting, limit results etc. ► Choose or create the destination sheet and start cell ► Prepare and Post data from Google Sheets into Apps ► Conditional Posting - Post your records to Apps when it meets your own custom conditions ► 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 notification is sent when there is a failure in processing the configured services. ► Execution Logs to monitor automated executions Automate your day-to-day reporting with awesome dashboard, visualizations from cross-platform/app data mashups. Sheet Director is a great API Connector/ Integrator and the best alternative/ complementary to Zapier, Supermetrics, Automate.io, Workato, SheetsGo, JSON Importer, etc. APPLICATIONS AND SERVICES Below are the applications supported along with services offered. Remember that there is no limit to your creativity to use Sheet Director wherever you feel it fits and whatever use cases that you may have. ֍ G Suite Apps to Google Sheets: ► Google Sheets ➥ Distribute - Segment data from a source sheet and send that data across 'n' number of sheets based on configuration. ➥ Backup - Take back up of Google Sheets by cloning/ copying into the preset folder. ► Email ➥ Send Email - Send contents from a Google Sheet 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 sheet. ► Google Calendar to Google Sheets ➥ Get Events - Query and pull calendar events from Google Calendar into Google Sheets. ➥ Post Events - Post Google Sheet data into calendar to create Calendar events. ► Google Tasks to Google Sheets ➥ Get Tasks - Pull all tasks from Google Tasks and present it 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. ► Google Classroom to Google Sheets ➥ Query - Query all contents from Google Classroom and present it in Google Sheet. ► Google Admin to Google Sheets ➥ Query - Query all contents from Google Admin and present it in Google Sheets. ► 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 Sheet. ► 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 a Google Sheets. ➥ Post - Push data from Google Sheets to 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. ► Xero to Google Sheets ➥ Query - Pull data from Xero and present it into Google Sheets. ➥ Post - Push data from Google Sheets to Xero ► Zoho Books to Google Sheets ➥ Query - Pull data from Zoho Books objects like invoices, expenses and present it into Google Sheets. ➥ Post - Push data from Google Sheets to Zoho Books objects. ► Zoho Invoice to Google Sheets ➥ Query - Pull data from Zoho invoices objects like contacts, invoices and present it into Google Sheets. ➥ Post - Push data from Google Sheets to Zoho invoice objects. ► Zoho Expense to Google Sheets ➥ Query - Pull data from Zoho Expenses objects like contacts, expenses and present it into Google Sheets. ► Wave to Google Sheets ➥ Query - Pull all the data from Wave objects and store it into a Spreadsheet ➥ Post - Push the data from Google Sheet into 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 spreadsheet to HubSpot. ► Salesforce to Google Sheets ➥ Query - Pull all contacts from Salesforce objects and store it into a spreadsheet. ➥ Post - Push all contacts from spreadsheet to Salesforce. ► Insightly to Google Sheets ➥ Query - Pull data from Insightly objects and store it into a spreadsheet. ➥ Post - Push data from spreadsheet to Insightly. ► Copper to Google Sheets ➥ Query - Pull data from Copper objects and store it into a spreadsheet. ➥ Post - Push data from spreadsheet to Copper. ► Capsule to Google Sheets ➥ Query - Pull data from Capsule objects and store it into a spreadsheet. ➥ Post - Push data from spreadsheet to Capsule. ► EngageBay to Google Sheets ➥ Query - Pull data from EngageBay objects and store it into a spreadsheet. ➥ Post - Push data from spreadsheet to EngageBay. ► Zoho CRM to Google Sheets ➥ Query - Pull data from Zoho CRM objects and store it into a spreadsheet. ➥ Post - Push data from spreadsheet to Zoho CRM. ► Agile CRM to Google Sheets ➥ Query - Pull data from Agile CRM objects and store it into a google sheet ➥ Post - Push data from Google sheet to Agile CRM. ► Vtiger CRM to Google Sheets ➥ Query - Pull data from Vtiger CRM objects and store it into a google sheet ֍ Productivity Apps to Google Sheets: ► Asana to Google Sheets ➥ Query - Pull data from Asana objects and store it into a spreadsheet. ➥ Post - Post data from Google Sheets into Asana objects. ► Trello to Google Sheets ➥ Query - Pull data from Trello objects and store it into a spreadsheet. ➥ Post - Post data from Google Sheets into Trello objects. ► Airtable to Google Sheets ➥ Query - Pull data from Airtable objects and store it into a spreadsheet. ► Smartsheet to Google Sheets ➥ Query - Pull data from Smartsheet and present it into Google Sheets. ➥ Post - Post data from Google Sheets into Smartsheet. ֍ Payment Apps to Google Sheets: ► PayPal to Google Sheets ➥ Query - Pull data from PayPal objects and store it into a spreadsheet. ► Stripe to Google Sheets ➥ Query - Pull data from Stripe objects and store it into a spreadsheet. ֍ Time tracking Apps to Google Sheets: ► Clockify to Google Sheets ➥ Query - Pull data from Clockify objects and store it into a spreadsheet. ► Harvest to Google Sheets ➥ Query - Pull data from Harvest objects and store it into a spreadsheet. ֍ Marketing Apps to Google Sheets: ► Mailchimp to Google Sheets ➥ List Members - Pull data from Mailchimp objects and store it into a spreadsheet. ➥ Post - Push data from spreadsheet to Mailchimp.EngageBay to Google Sheet ► Active Campaign ➥ Query - Pull data from ActiveCampaign objects and store it into a spreadsheet. ➥ Post - Push data from spreadsheet to ActiveCampaign. ► Get Response to Google Sheets ➥ Query - Pull data from GetResponse objects and store it into a spreadsheet. ➥ Post - Push data from spreadsheet to GetResponse. ֍ Ticketing Apps to Google Sheets: ► Zendesk to Google Sheets ➥ Query - Pull data from Zendesk objects and store it into a spreadsheet. ► Freshdesk to Google Sheets ➥ Query - Pull data from Freshdesk objects and store it into a spreadsheet. ► JIRA to Google Sheets ➥ Query - Pull data from JIRA entities and store it into a spreadsheet. ► Zoho Desk to Google Sheets ➥ Query - Pull data from Zoho Desk objects and store it into a google sheet ֍ 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 into a spreadsheet. ► Zoho Bugtracker to Google Sheets ➥ Query - Pull data from Zoho Bugtracker entities and store it into a spreadsheet. ► Zoho Subscriptions to Google Sheets ➥ Query - Pull data from Zoho Subscriptions objects and store it into a spreadsheet. Zoho Creator to Google Sheets ► Query - Pull data from Zoho Creator objects and store it into a spreadsheet. SUPPORT For more details refer 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