Step 2 of 10

Connect the form to Google Sheets

Create the storage layer - alinked Google Sheet that automatically receives every new form submission as a structured row.

Why this matters

The spreadsheet is your operational database. Zapier reads from it to trigger the workflow. If form responses go to the wrong sheet, have mismatched column headers, or are missing the test row needed to configure Zapier, you will not be able to set up the trigger in Step 4.

Build instructions

Link the form to a new spreadsheet

Step 1
In the form editor, click the 'Responses' tab at the top of the page (next to Questions).
Step 2
Look for the green Sheets icon in the top right corner of the Responses panel. Click it. A dialog appears with two options: 'Create a new spreadsheet' and 'Select existing spreadsheet'.
Step 3
Choose 'Create a new spreadsheet'. In the name field, clear the default name and type 'Lead Inquiry Responses'. Click Create.
Step 4
Google Sheets opens in a new browser tab. The sheet is already populated with a header row and any responses you collected during testing.

Verify the sheet structure

Step 1
Check that Row 1 (the header row) contains exactly these columns in order: Timestamp, Full Name, Email Address, Inquiry Type, Message. The Timestamp column is added automatically by Google Forms.
Step 2
If any column header does not match your field name (for example, 'Email' instead of 'Email Address'), do NOT rename it in the sheet. Go back to the form and rename the field there, the sheet updates automatically.
Step 3
Check that your test submission from Step 1 appears as Row 2 with data in all five columns.

Submit a second test response

Step 1
Go back to the form editor tab. Click the eye (Preview) icon to open the form.
Step 2
Fill in the form with different data from your first test. Use a different name and email. Choose a different Inquiry Type.
Step 3
Submit. Go back to the Google Sheet and confirm a new Row 3 has appeared. You should now have two data rows below the header.
Step 4
Zapier needs at least one data row to load sample fields when you configure the trigger. Two rows give you more options to test with.

Common mistakes

Renaming column headers directly in the sheet. If you rename 'Email Address' to 'Email' in the sheet, Zapier maps to 'Email' but your form still labels the field 'Email Address'. This causes confusion. Always rename in the form, the sheet updates automatically.
Linking to an existing sheet with unrelated data. Always create a new sheet specifically for this project. Mixing this data with other spreadsheet data causes Zap mapping errors.
Proceeding with zero data rows in the sheet. Zapier requires at least one real data row to show you sample fields during trigger setup. Without it, you cannot map fields and will need to come back to this step.

Pro tips

Freeze Row 1 in Google Sheets (View → Freeze → 1 row). This keeps headers visible as you scroll down through hundreds of lead rows.
Bookmark the spreadsheet URL right now. You will need it in Step 4 when setting up the Zapier trigger.

Before you continue

Open the Google Sheet. You should see a header row (Row 1) and at least two data rows (Rows 2 and 3) with real data. All five columns: Timestamp, Full Name, Email Address, Inquiry Type, Message, should be present and correctly labeled.

Step result

Every new lead submission now automatically creates a new row in the sheet. The sheet is ready to use as the Zapier trigger source.