If you have existing data in a spreadsheet, sometimes it might be good to amend that, especially if someone fills out a form on your website. Use Zapier to update existing spreadsheet rows and always keep that data up to date.

How this Google Forms-Google Sheets integration works

Apps involved

Update Google Sheets rows from new Google Forms responses

If you have existing data in a spreadsheet, sometimes it might be good to amend that, especially if someone fills out a form on your website. Use Zapier to update existing spreadsheet rows and always keep that data up to date.

How this Google Forms-Google Sheets integration works

You have a new form response

Zapier updates a spreadsheet row

Apps involved

Giving your customers a quick, detailed response to their requests can help you secure business and loyalty. This integration allows you to handle every incoming request, find the appropriate answers in your database, and reply with a customized presentation.

Once active, it will trigger whenever someone submits a new response to your Google Form. It will then search Google Sheets for the row that matches a response that was given, and update a Google Slides presentation by replacing blanks with a combination of the information provided by your customer and the details that were found in the Google Sheet. This customized presentation will then be emailed to your respondent, and you can add your email to the cc field so you can watch for the response to your proposal.

Note: This workflow assumes certain components of your form, slide, and spreadsheet are named in a certain way. Be sure to insert the correct values if you don't use the provided templates

How this Google Forms-Google Sheets-Google Slides-Gmail integration works

A new response is submitted to your Google Form

Zapier finds matching information on a Google Sheet

Zapier replaces variables in your Google Slides with information from your form and spreadsheet

Zapier emails a customized version of your presentation to your form respondent via Gmail

Apps involved

Assign BigML anomaly scores to new Google Forms responses and store them in Google Sheets

If you use Google Forms to survey your customers, you could want to spot those responses that look "anomalous" to you, according to your own definition of what an anomalous response is. Even better, if you label past responses you received as "normal" or "anomalous", you can train a BigML model that is able to automatically spot "anomalous" responses for you. This integration allows you to automatically assign an anomaly score to all new responses you get and update your forms data with that anomaly score.

Note: This Zapier integration does not provide a ready-to-use anomaly detector. You can train one using the BigML Dashboard with your own data.

How this Google Forms-BigML-Google Sheets integration works

A customer sends in their responses to a Google Form

Zapier uses BigML to associate an anomaly score to it

The anomaly score is stored in a Google Sheets spreadsheet

Apps involved

Determine the validity of email addresses entered into your Google Forms with NeverBounce. When a new response is submitted in Google Forms, a new row is added to the bottom of your Google Forms Responses Sheet. The value in the email address column is then verified by NeverBounce. The email address’ returned result code — valid, invalid, disposable, catch-all, unknown — is then added to the Google Forms Responses Sheet in a custom column.

*Note: You may need to create a new column inside the Google Form Responses Sheet to store the validation result. We recommend keeping NeverBounceValidationResult as the column header *

How this Google Forms-NeverBounce integration works

A new Google Forms response is recorded

Zapier sends the email to be verified with NeverBounce

Zapier updates the existing Google Sheets row with NeverBounce result code in a custom column

Apps involved

Analyze sentiment of new Google Forms responses with MeaningCloud and log the results in Google Sheets

Make the most of the responses obtained from your customers in Google Forms. Once activated, whenever your customer submits a new response via Google Forms, MeaningCloud will extract the sentiment expressed in the free-text answers and adds it to Google Sheets, allowing you to leverage the unstructured information easily.

How this Google Forms-MeaningCloud-Google Sheets integration works

A new response is submitted to your Google Form

MeaningCloud analyzes the sentiment of the free-text answers

Zapier finds the Google Sheets row in where the response is stored

Zapier adds the sentiment analysis to the Google Sheets row with the response