Pass Google Forms Responses to Google Sheets via Zapier

Quick summary

This tutorial shows how to connect Google Forms to Google Sheets using a Zapier automation, so every new form response is instantly logged as a new spreadsheet row without manual data entry. By setting up this Zap, teams can collect, organize, and act on form data in real time across both Google Workspace tools.

Steps

1. Log in to Zapier, click "Create," and select "Zaps" to start building your automation.
2. Click "Trigger" to begin configuring the trigger step of your Zap.
3. Search for and select Google Forms as the trigger app.
4. Choose a trigger event, such as "New Response in Spreadsheet," to define what activates the Zap.
5. Connect your Google account to Zapier to grant access to your Forms data.
6. Select the specific Google Form response sheet you want Zapier to monitor.
7. Run a test to ensure Zapier detects the form data correctly.
8. Add Google Sheets as the Action App in your Zap.
9. Choose "Create Spreadsheet Row" as the action event to define what happens when the trigger fires.
10. Connect your Google Sheets account to Zapier to grant write access.
11. Select the target Google Sheet and map form fields to columns in the spreadsheet.
12. Run a test to verify that form responses are correctly passed to Google Sheets.
13. Click "Publish" to activate your Zap and start the live automation.