Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate Google Forms with Google Sheets - no code necessary. See how you can get setup in minutes.
100%
Help
Google Forms
Google Forms
1. Choose trigger event
Google Sheets
Google Sheets
2. Choose action
1. Select the event
Setup
Test
Google Forms
Choose a trigger event
Choose a trigger
A trigger is the event that starts your Zap—like a "New Form Response" from Google Forms.
Add your action
An action happens after the trigger—such as "Create Spreadsheet Column" in Google Sheets.
You’re connected!
Zapier seamlessly connects Google Forms and Google Sheets, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
Use Timezone set up on the spreadsheet to format date values?
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Cell Range
Required
Condition Type
Required
Background Color
Text Color
Bold Text
Italic Text
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet Containing the Worksheet to Copy
Required
Worksheet to Copy
Required
Copy Worksheet Destination
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Title
Required
Overwrite existing worksheet with the same title
Headers
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Confirm Deletion
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Cell Range
Required
Format Type
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Spreadsheet
Required
Worksheet
Required
New Sheet Name
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Cell Range
Required
Sort by Column
Required
Sort Order
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Lookup column
Required
Lookup value
Required
Supporting lookup column
Supporting lookup value
Search from last row
First row
Row count
Action
This is an event a Zap performs.
Search
Find existing data in your app
Drive
Spreadsheet
Required
Title
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Drive
Spreadsheet
Required
Worksheet
Required
Columns
Required
Row count
Required
Output format
First row
Action
This is an event a Zap performs.
Search
Find existing data in your app
Spreadsheet ID
Required
Include Grid Data
Action
This is an event a Zap performs.
Search
Find existing data in your app
Drive
Spreadsheet Name
Required
Search Type
Spreadsheet to Copy
Headers
Action
This is an event a Zap performs.
Search or write
Find existing data in your app, or create a new record if no data is found
Drive
Spreadsheet
Required
Worksheet
Required
Lookup column
Required
Lookup value
Required
Supporting lookup column
Supporting lookup value
Search from last row
Row count
Action
This is an event a Zap performs.
Search or write
Find existing data in your app, or create a new record if no data is found
For AI agents & developers
Use Google Forms and Google Sheets with AI agents and code
Beyond Zap workflows. Call Google Forms and Google Sheets actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.
No code
Connect via Zapier MCP
Expose Google Forms and Google Sheets actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
API Request (Beta)
Create Spreadsheet Column
Works with
Claude · ChatGPT · Cursor · any MCP-compatible client
There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Practical ways you can use Google Forms and Google Sheets
Document form responses in a Google Sheet.
When a new form response is submitted in Google Forms, Zapier automatically adds it to Google Sheets. This eliminates manual data entry, ensuring accurate and timely tracking of form submissions. It's particularly helpful for surveys, registrations, or customer feedback.
When someone fills out a Google Form for campaign feedback, Zapier automatically logs the data into Google Sheets. This allows marketers to monitor responses as they come in, analyze the data quickly, and make informed, data-driven adjustments to campaigns.
When a new project update is submitted through Google Forms, Zapier automatically records the details in Google Sheets. This provides project managers with an organized and centralized record of updates, helping to understand project progress and distribute work efficiently.
Learn how to automate Google Forms on the Zapier blog
Learn how to automate Google Sheets on the Zapier blog
Make work flow with AI
Level up your Google Forms to Google Sheets integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Frequently Asked Questions about Google Forms + Google Sheets integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Google Forms and Google Sheets
How do I connect Google Forms to Google Sheets?
To connect Google Forms to Google Sheets, you need to set a trigger for new form responses. You can create a direct link from the Google Forms settings, ensuring that all response data automatically populates a specified sheet in your chosen spreadsheet.
Can I customize which data from my Google Form goes into my Google Sheet?
Yes, you can customize which fields appear in your Google Sheet by setting specific form questions that directly map to columns in your sheet. This ensures that only necessary information is recorded and organized accordingly.
What happens if I edit a response in Google Forms?
When you edit a response in Google Forms, the corresponding entry in the connected Google Sheet is updated automatically. This happens because our system triggers an update action when changes are detected.
Is it possible for multiple forms to feed into one sheet?
Yes, you can have multiple forms feeding into different tabs of a single spreadsheet. Each form requires its own set of triggers and actions to ensure responses are correctly sorted into designated sections.
Can I filter responses before they reach my Google Sheet?
Filtering responses prior to them reaching your Google Sheet isn't available within the basic integration features. However, by using advanced scripts or add-ons, we provide options for more customized filtering actions.
Will deleting a form affect its data in my spreadsheet?
Deleting a form will not remove the data from your spreadsheet as long as the spreadsheet exists separately and has been saving records independently of the live form's status.
How do we handle responses if there are changes made to the questions on a live form?
If changes are made to questions on a live form, new responses will reflect these changes while maintaining historical response integrity. Our integration updates field mappings dynamically when modifications are detected in your forms.
About Google Forms
Google Forms is an easy way to collect data from the web with a simple UI and powerful editor. Works hand-in-hand with Google Sheets!
