Integrating Google Forms using Zoho Flow

Integrating Google Forms using Zoho Flow

Google Forms has become a popular web-form tool for collecting contacts, surveys, and quizzes. Creating a form and consolidating the responses in a spreadsheet is a straightforward process and takes only a few minutes. However, what if you need to use the collected data more effectively, for tasks such as sending automated emails for each new response, notifying your team in Slack, and adding leads to your CRM application?

Manually converting your form's responses into useful tasks is a waste of your valuable time. With automation, your workflow can detect a form submission, decide what to do with the response data, and distribute it to the apps of your choice. The possibilities are endless.


How do you automate such workflows?

Workflow automation can be implemented in many ways. Using code is one way of achieving it, but this can be tricky for most practical applications. A workflow automation platform like Zoho Flow can be incredibly useful in circumventing this. It allows you to automate tasks by integrating your favorite apps, controlling and manipulating data that flows between them.

For example, every time a form submission is made, Flow will automatically take in the response and move it to other apps, such as Slack, Zoho CRM, or ActiveCampaign. Let's take a look at how this can be achieved.

Generally, all you need to do is to create a new flow, select a trigger, and then add actions. However, some applications, such as Google Forms, do not provide public API for integrations. To integrate applications for which APIs are not available, or if there are limitations to the available APIs, you can use the webhook trigger available in Zoho Flow to achieve the same results.

What you will need

  • A Google account
  • A Zoho Flow account

Getting started: Creating your Google Form

Once you have logged in to your Google account, you can go to docs.google.com/forms to start creating your new form. Even better, you can create a sheet in Google Sheets, click on Tools > Create a form to create one. All the responses that it collects get saved automatically in that spreadsheet.

Work with the title, form fields, and other options to create the form that you would like to use. 

Adding a Form Project: Google Forms Script editor

  1. Navigate to the More menu (the 3 dots) on the top right corner, adjacent to the SEND button. Click Script editor. This will open a new tab containing a console.

  2. Clear the existing contents in that console and copy the following content into it.
     
    
    function onFormSubmit(form) {
    	var formResponses = form.response.getItemResponses();
    	var responsePayload = new Object();
    	for (var i = 0; i < formResponses.length; i++) {
    		responsePayload[form.response.getItemResponses()[i].getItem().getTitle()] = form.response.getItemResponses()[i].getResponse();
    	}
    	console.log(responsePayload);
    	var url = "WEBHOOK URL";
    	var options = {
    		"method": "post",
    		"headers": {},
    		"payload": responsePayload
    	};
    	var response = UrlFetchApp.fetch(url, options);
    }
    
    



  3. Save your project by clicking the Save button.
  4. Navigate to the left panel, then click Triggers


  5. Click Add Trigger. In the follow dialog box, select the Event type as On form submit, then click SAVE.



  6. You will be asked to select your Google account. Since you are inserting a code, it will ask you to proceed only if you trust the developer. Do not worry. Click Advanced, then click Go to <your project>.

  7. Click Allow in the next step.

Adding automation : Using Zoho Flow's Webhook trigger

A trigger in Flow refers to an event that activates your flow. In this case, the trigger will be a webhook. The webhook trigger in Zoho Flow generates a unique URL, which can be used in third party applications (like Google Forms in this scenario) to send data to Flow in real time whenever a form submission has been made. Once the data reaches Flow, you can move it to other applications of your choice.

Setting up the trigger

To set up a webhook trigger, follow these steps:

  1. Log in to Zoho Flow in a new tab and create a new flow.
  2. Click Configure in the webhook trigger box.

  3. Copy the generated URL from the configuration window that opens, then click NEXT.

  4. Go back to Google Forms Script editor tab and replace WEBHOOK URL with the copied URL within the quotes. Do not remove the quotes.

  5. Navigate to File Save.
  6. Return to Zoho Flow and click TEST. You have the option of making a sample form submission to test if it is working perfectly. Click DONE.

  7. Connect actions or decisions to the Webhook trigger in the Flow Builder. All responses in your form will be available as Variables in the INSERT VARIABLE panel.


      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        Access your files securely from anywhere

          Zoho CRM Training Programs

          Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

          Zoho CRM Training
            Redefine the way you work
            with Zoho Workplace

              Zoho DataPrep Personalized Demo

              If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

              Zoho CRM Training

                Create, share, and deliver

                beautiful slides from anywhere.

                Get Started Now


                  Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                  BOOK A SESSION







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsRetailOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceForms for Solopreneurs
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Forms for Government
                              Intake FormsLegal
                              Mobile App
                              Form DesignerHR
                              Mobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic FormsInsurance
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsWufoo alternativeEncrypted Forms
                              Accessible FormsTypeform alternativeSecure Forms

                              WCAG

                                          Create. Review. Publish.

                                          Write, edit, collaborate on, and publish documents to different content management platforms.

                                          Get Started Now






                                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                                Manage your brands on social media

                                                                  Use cases

                                                                  Make the most of Zoho Desk with the use cases.

                                                                   
                                                                    

                                                                  eBooks

                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                                   
                                                                    

                                                                  Videos

                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                                   
                                                                    

                                                                  Webinar

                                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                                   
                                                                    
                                                                  • Desk Community Learning Series


                                                                  • Meetups


                                                                  • Ask the Experts


                                                                  • Kbase


                                                                  • Resources


                                                                  • Glossary


                                                                  • Desk Marketplace


                                                                  • MVP Corner



                                                                    Zoho Sheet Resources

                                                                     

                                                                        Zoho Forms Resources


                                                                          Secure your business
                                                                          communication with Zoho Mail


                                                                          Mail on the move with
                                                                          Zoho Mail mobile application

                                                                            Stay on top of your schedule
                                                                            at all times


                                                                            Carry your calendar with you
                                                                            Anytime, anywhere




                                                                                  Zoho Sign Resources

                                                                                    Sign, Paperless!

                                                                                    Sign and send business documents on the go!

                                                                                    Get Started Now




                                                                                            Zoho TeamInbox Resources





                                                                                                      Zoho DataPrep Demo

                                                                                                      Get a personalized demo or POC

                                                                                                      REGISTER NOW


                                                                                                        Design. Discuss. Deliver.

                                                                                                        Create visually engaging stories with Zoho Show.

                                                                                                        Get Started Now









                                                                                                                            • Related Articles

                                                                                                                            • Zoho Meeting

                                                                                                                              What is Zoho Meeting? Zoho Meeting is a secure online meeting platform and webinar solution that helps people find new ways to collaborate and work remotely with efficacy. How to connect your Zoho Meeting account to Zoho Flow Select the trigger or ...
                                                                                                                            • Zoho Forms

                                                                                                                              What is Zoho Forms? Zoho Forms is a form builder solution that helps you create, share, and collect data through forms for all your business needs. You can also create custom data reports, configure email notifications, assign tasks and approvals to ...
                                                                                                                            • Google Sheets

                                                                                                                              What is Google Sheets? Google Sheets lets you create and edit spreadsheets online. You can collaborate with others, define formulas, and easily create graphs and charts. How to connect your Google Sheets account to Zoho Flow Select the required ...
                                                                                                                            • Zoho Flow Plugin for WordPress

                                                                                                                              The Zoho Flow WordPress plugin lets you integrate 30+ WordPress plugins, such as Gravity Forms, Elementor, Ninja Forms, and LearnDash with, hundreds of other apps you use. Installation requirements Minimum requirements: WordPress 4.4 or greater PHP ...
                                                                                                                            • Everest Forms

                                                                                                                              What is Everest Forms? Everest Forms is a drag-and-drop form builder plugin that lets you create beautiful forms, including contact forms, within minutes. The plugin is lightweight, fast, and mobile responsive. How to connect Everest Forms to Zoho ...
                                                                                                                              Wherever you are is as good as
                                                                                                                              your workplace

                                                                                                                                Resources

                                                                                                                                Videos

                                                                                                                                Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                eBooks

                                                                                                                                Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                Webinars

                                                                                                                                Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                CRM Tips

                                                                                                                                Make the most of Zoho CRM with these useful tips.



                                                                                                                                  Zoho Show Resources