1) Moving Custom Objects between Google Sheets and Salesforce<\/h3>\n\n\n\n![\"\"](\"https:\/\/www.workato.com\/the-connector\/wp-content\/uploads\/2026\/09\/Untitled-design-98.png\")
<\/figure>\n<\/div>\n\n\nSalesforce is a great tool for managing customer relationships for both sales and customer support. Using custom objects allows you tweak SFDC to your specific business needs\u2014but what about the information that populates those custom fields? Making sure it\u2019s accurate is important; reps should have all the information they need to deliver stellar service and close deals. But the process of updating it from an external source (like a spreadsheet) can be frustrating and time-consuming\u2014unless you\u2019ve integrated Sheets with Salesforce!<\/p>\n\n\n\n
Chicago Scholars is a nonprofit organization that helps students apply to college and supports them during their time in school. The organization also helps to place students in jobs and internships, so they maintain a job board<\/a> for listings. They use Workato to automatically update the board by integrating Salesforce<\/a> with Google Sheets<\/a>. \u201cOur job board is hosted using Awesome Tables, which displays the contents of a Google Sheet. Because this was really complex to maintain, we created a custom object in Salesforce to track all job board postings,\u201d says Tony Calero, Director of Data Management and Analytics.<\/p>\n\n\n\nNow, when there are any new or updated records in Salesforce, this Workato recipe<\/a> updates the Google Sheet, which in turn updates the Awesome Table widget displaying the job board. This ensures the job board is always up to date for the students without wasting precious staff time to manually maintain the board.<\/p>\n\n\n\n2) Automatically Analyzing Data with Google Sheets<\/h3>\n\n\n\n![\"\"](\"https:\/\/www.workato.com\/the-connector\/wp-content\/uploads\/2026\/09\/Untitled-design-94.png\")
<\/figure>\n<\/div>\n\n\nGoogle Sheets is a powerful tool for analyzing data, but you must get your data into a Sheet first. You can use automation to move data from different apps into a Sheet seamlessly, but what about gaining actionable insights? With integration, you can automatically perform single-value checks on the Sheet’s data. You can even send notifications to the appropriate person via Slack\u2014with no manual effort!<\/p>\n\n\n\n
At Workato, we decided to build a \u201cCustomer Happiness Meter” to better manage customer churn. This tool involves customer information from the various apps we use at Workato\u2014like Intercom<\/a>, FreshDesk<\/a>, Salesforce<\/a>, and Stripe<\/a>\u2014and moving it into Google Sheets where we can analyze all the data together and predict which customers might churn based on this information. We move the customer information into Google Sheets with a series of Workato recipes that gather key information on all our paying customers from each app. This key information includes things like the customer\u2019s Workato subscription plan, chat activity, support ticket submissions, recipe activity, which apps are connected and more.<\/p>\n\n\n\nBringing all of this information in Google Sheets allows us to get an overview of how each customer account is doing. Once the information is in the Google Sheet, there are several indications of churn that Workato will note (Workato will perform single-value checks for indicators like zero active recipes, or customer has an open ticket). These red flags are included in a weekly notification to the Customer Success agent who is assigned to that customer account.<\/p>\n\n\n\n
We created this workflow using the following recipes:<\/p>\n\n\n\n
\n- Update CSR Assignment worksheet with account updates<\/a><\/li>\n\n\n\n
- Get main contact details<\/a><\/li>\n\n\n\n
- Populate salesperson<\/a><\/li>\n\n\n\n
- Get account plan, subscription amount, and renewal date<\/a><\/li>\n\n\n\n
- Schedule call to retrieve account info<\/a><\/li>\n\n\n\n
- Get convo and ticket numbers<\/a><\/li>\n<\/ul>\n\n\n\n
3) Saving Energy and Time with Gmail and Quickbase<\/h3>\n\n\n\n![\"\"](\"https:\/\/www.workato.com\/the-connector\/wp-content\/uploads\/2026\/09\/Untitled-design-95.png\")
<\/figure>\n<\/div>\n\n\nQuickBase is a handy tool for creating custom-built apps, even if you\u2019re not a developer by trade. But even a custom built app can\u2019t do everything! You still may need to move information from your app into other programs. And you definitely need your app to fit seamlessly into your existing workflows, like lead follow-up.<\/p>\n\n\n\n
greeNEWit, an energy efficiency company, uses G Suite automation to build new revenue streams through customer follow-up. With Workato, they implemented single stream drip campaigns with a high clickthrough rate. \u201cBy integrating QuickBase<\/a> with Gmail<\/a>, we avoid getting caught in promotional filters. We know our emails are getting to the client,\u201d says Brad Eisenberg, former COO. They can also customize the content based on the recipient\u2019s identity\u2014a process they just wouldn\u2019t have the bandwidth to do manually. These campaigns resulted in an increase in repeat customers, helping the company automatically follow up with customers after the job is completed.<\/p>\n\n\n\n4) Creating Seamless Approval Workflows with Google Sheets<\/h3>\n\n\n\n![\"\"](\"https:\/\/www.workato.com\/the-connector\/wp-content\/uploads\/2026\/09\/Untitled-design-96.png\")
<\/a><\/figure>\n<\/div>\n\n\n
Google Forms are a useful tools for collecting sign-ups, opinions, and contact info. Form results are stored as a spreadsheet in Google Sheets\u2014but what if you need to move those results into another app, like Marketo or a custom-built internal application? If your workflows require human approval for some steps, this can be especially tricky; if a request is approved or denied, you need its status to update right away, across all your apps. Integration can automate the process, so your data goes where it should, without you doing any manual data entry!<\/p>\n\n\n\n
Here at Workato, we run a Partner Program designed to give consultants all the tools they need to use Workato for their client\u2019s integration workflows. As interest in the program grew, we needed a way to automate the signup process\u2014including an approval step done by a human. Partners sign up via a Google Form which sends the responses to Google Sheets, while our contracts are sent with DocuSign<\/a>. We created a recipe<\/a> to automate the approval process using our special People Task app, which builds in a human work ow step into any automation. When a partner signs up on Google Forms, People Task brings the application submission from Google Sheets to an employee for approval by emailing a link. The employee can simply click the link, view the application, and then click approve or reject.<\/p>\n\n\n\nIf the employee approves the application, the recipe will send a DocuSign contract that is populated with the correct information from the Google Sheet to the applicant for signature. If the employee rejects the application, an email will automatically be sent to the applicant asking for more information. Once accepted, partners need to sign a contract and then be granted access to our partner portal to view their dashboard. This recipe populates a Google Sheets column when the DocuSign contract is signed, triggering a Task asking a Workato employee to give the partner access to the portal. It will then send a welcome email to the approved partner automatically.<\/p>\n\n\n\n
We created this workflow using the following recipes:<\/p>\n\n\n\n
\n- Google Sheets to DocuSign<\/a><\/li>\n\n\n\n
- DocuSign to Google Sheets<\/a><\/li>\n<\/ul>\n\n\n\n
5) With Slack and Gmail, You’ll Never Miss an Email Again<\/h3>\n\n\n\n![\"\"](\"https:\/\/www.workato.com\/the-connector\/wp-content\/uploads\/2026\/09\/Untitled-design-89.png\")
<\/figure>\n<\/div>\n\n\nChat apps like Slack are increasingly becoming a workflow hub, but some messages can only be conveyed via email. If you spend your entire day in Slack, you may forget to check your email regularly and miss important news or updates.<\/p>\n\n\n\n
This recipe<\/a> alerts you to new Gmail messages in the channel of your choice. And it\u2019s completely customizable, so if you only want alerts for emails from VIP clients (or your boss!), you can set the recipe to notify you conditionally. You can even pick keywords to be alerted to, like \u201cmeeting” or “update.”<\/p>\n\n\n\n6) Slack Notifications for Google Doc Updates<\/h3>\n\n\n\n![\"\"](\"https:\/\/www.workato.com\/the-connector\/wp-content\/uploads\/2026\/09\/Untitled-design-97.png\")
<\/figure>\n<\/div>\n\n\nGoogle Drive<\/a> is a great way to collaborate with others in your organization. You can share, draft, and edit docs as a team. If you’re working with a high volume of documents, though, it’s easy for one to get lost in the shuffle or forgotten about. Linking Drive with Slack allows you to receive periodic reminders about important content\u2014individually, or as a channel.<\/p>\n\n\n\nAt Workato, each employee shares a weekly status update with the company. We use these updates to track projects, celebrate accomplishments, and provide assistance to colleagues who need a helping hand. The marketing team submits their weekly report as a team, with everyone’s updates in one Google Doc. To make sharing the report easier, the marketing team uses this recipe<\/a> to send the weekly report to their Slack channel on a weekly basis.<\/p>\n\n\n\n
<\/figure>\n<\/div>\n\n\nSalesforce is a great tool for managing customer relationships for both sales and customer support. Using custom objects allows you tweak SFDC to your specific business needs\u2014but what about the information that populates those custom fields? Making sure it\u2019s accurate is important; reps should have all the information they need to deliver stellar service and close deals. But the process of updating it from an external source (like a spreadsheet) can be frustrating and time-consuming\u2014unless you\u2019ve integrated Sheets with Salesforce!<\/p>\n\n\n\n
Chicago Scholars is a nonprofit organization that helps students apply to college and supports them during their time in school. The organization also helps to place students in jobs and internships, so they maintain a job board<\/a> for listings. They use Workato to automatically update the board by integrating Salesforce<\/a> with Google Sheets<\/a>. \u201cOur job board is hosted using Awesome Tables, which displays the contents of a Google Sheet. Because this was really complex to maintain, we created a custom object in Salesforce to track all job board postings,\u201d says Tony Calero, Director of Data Management and Analytics.<\/p>\n\n\n\n Now, when there are any new or updated records in Salesforce, this Workato recipe<\/a> updates the Google Sheet, which in turn updates the Awesome Table widget displaying the job board. This ensures the job board is always up to date for the students without wasting precious staff time to manually maintain the board.<\/p>\n\n\n\n Google Sheets is a powerful tool for analyzing data, but you must get your data into a Sheet first. You can use automation to move data from different apps into a Sheet seamlessly, but what about gaining actionable insights? With integration, you can automatically perform single-value checks on the Sheet’s data. You can even send notifications to the appropriate person via Slack\u2014with no manual effort!<\/p>\n\n\n\n At Workato, we decided to build a \u201cCustomer Happiness Meter” to better manage customer churn. This tool involves customer information from the various apps we use at Workato\u2014like Intercom<\/a>, FreshDesk<\/a>, Salesforce<\/a>, and Stripe<\/a>\u2014and moving it into Google Sheets where we can analyze all the data together and predict which customers might churn based on this information. We move the customer information into Google Sheets with a series of Workato recipes that gather key information on all our paying customers from each app. This key information includes things like the customer\u2019s Workato subscription plan, chat activity, support ticket submissions, recipe activity, which apps are connected and more.<\/p>\n\n\n\n Bringing all of this information in Google Sheets allows us to get an overview of how each customer account is doing. Once the information is in the Google Sheet, there are several indications of churn that Workato will note (Workato will perform single-value checks for indicators like zero active recipes, or customer has an open ticket). These red flags are included in a weekly notification to the Customer Success agent who is assigned to that customer account.<\/p>\n\n\n\n We created this workflow using the following recipes:<\/p>\n\n\n\n QuickBase is a handy tool for creating custom-built apps, even if you\u2019re not a developer by trade. But even a custom built app can\u2019t do everything! You still may need to move information from your app into other programs. And you definitely need your app to fit seamlessly into your existing workflows, like lead follow-up.<\/p>\n\n\n\n greeNEWit, an energy efficiency company, uses G Suite automation to build new revenue streams through customer follow-up. With Workato, they implemented single stream drip campaigns with a high clickthrough rate. \u201cBy integrating QuickBase<\/a> with Gmail<\/a>, we avoid getting caught in promotional filters. We know our emails are getting to the client,\u201d says Brad Eisenberg, former COO. They can also customize the content based on the recipient\u2019s identity\u2014a process they just wouldn\u2019t have the bandwidth to do manually. These campaigns resulted in an increase in repeat customers, helping the company automatically follow up with customers after the job is completed.<\/p>\n\n\n\n Here at Workato, we run a Partner Program designed to give consultants all the tools they need to use Workato for their client\u2019s integration workflows. As interest in the program grew, we needed a way to automate the signup process\u2014including an approval step done by a human. Partners sign up via a Google Form which sends the responses to Google Sheets, while our contracts are sent with DocuSign<\/a>. We created a recipe<\/a> to automate the approval process using our special People Task app, which builds in a human work ow step into any automation. When a partner signs up on Google Forms, People Task brings the application submission from Google Sheets to an employee for approval by emailing a link. The employee can simply click the link, view the application, and then click approve or reject.<\/p>\n\n\n\n If the employee approves the application, the recipe will send a DocuSign contract that is populated with the correct information from the Google Sheet to the applicant for signature. If the employee rejects the application, an email will automatically be sent to the applicant asking for more information. Once accepted, partners need to sign a contract and then be granted access to our partner portal to view their dashboard. This recipe populates a Google Sheets column when the DocuSign contract is signed, triggering a Task asking a Workato employee to give the partner access to the portal. It will then send a welcome email to the approved partner automatically.<\/p>\n\n\n\n We created this workflow using the following recipes:<\/p>\n\n\n\n Chat apps like Slack are increasingly becoming a workflow hub, but some messages can only be conveyed via email. If you spend your entire day in Slack, you may forget to check your email regularly and miss important news or updates.<\/p>\n\n\n\n This recipe<\/a> alerts you to new Gmail messages in the channel of your choice. And it\u2019s completely customizable, so if you only want alerts for emails from VIP clients (or your boss!), you can set the recipe to notify you conditionally. You can even pick keywords to be alerted to, like \u201cmeeting” or “update.”<\/p>\n\n\n\n Google Drive<\/a> is a great way to collaborate with others in your organization. You can share, draft, and edit docs as a team. If you’re working with a high volume of documents, though, it’s easy for one to get lost in the shuffle or forgotten about. Linking Drive with Slack allows you to receive periodic reminders about important content\u2014individually, or as a channel.<\/p>\n\n\n\n At Workato, each employee shares a weekly status update with the company. We use these updates to track projects, celebrate accomplishments, and provide assistance to colleagues who need a helping hand. The marketing team submits their weekly report as a team, with everyone’s updates in one Google Doc. To make sharing the report easier, the marketing team uses this recipe<\/a> to send the weekly report to their Slack channel on a weekly basis.<\/p>\n\n\n\n2) Automatically Analyzing Data with Google Sheets<\/h3>\n\n\n
<\/figure>\n<\/div>\n\n\n\n
3) Saving Energy and Time with Gmail and Quickbase<\/h3>\n\n\n
<\/figure>\n<\/div>\n\n\n4) Creating Seamless Approval Workflows with Google Sheets<\/h3>\n\n\n
<\/a><\/figure>\n<\/div>\n\n\n
Google Forms are a useful tools for collecting sign-ups, opinions, and contact info. Form results are stored as a spreadsheet in Google Sheets\u2014but what if you need to move those results into another app, like Marketo or a custom-built internal application? If your workflows require human approval for some steps, this can be especially tricky; if a request is approved or denied, you need its status to update right away, across all your apps. Integration can automate the process, so your data goes where it should, without you doing any manual data entry!<\/p>\n\n\n\n\n
5) With Slack and Gmail, You’ll Never Miss an Email Again<\/h3>\n\n\n
<\/figure>\n<\/div>\n\n\n6) Slack Notifications for Google Doc Updates<\/h3>\n\n\n
<\/figure>\n<\/div>\n\n\n