Zapier -> Google Sheets
2 min read
Log calculator leads to Google Sheets with a Zapier Catch Hook.
Overview
This Zap adds a row to Google Sheets whenever Made For Law sends a lead.created webhook to Zapier. Use this as the first integration test because the result is easy to verify.
Setup
1
Create a spreadsheet
Create a Google Sheet with columns matching the fields you want to capture:
| A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|
| Created At | First Name | Last Name | Phone | State | Calculator | Source URL |
2
Create the Zapier trigger
- In Zapier, click Create Zap.
- Choose Webhooks by Zapier as the trigger app.
- Choose Catch Hook as the trigger event.
- Copy the webhook URL.
- Paste the URL in Made For Law under Settings > Integrations > Lead Routing.
- Send a test lead from Made For Law and confirm Zapier caught it.
3
Add Google Sheets action
- Choose Google Sheets as the action app.
- Choose Create Spreadsheet Row.
- Connect your Google account.
- Select the spreadsheet and worksheet.
4
Map fields
Map the sample lead fields to your spreadsheet columns:
| Google Sheets column | Zapier field |
|---|---|
| Created At | lead.created_at |
| First Name | lead.first_name |
| Last Name | lead.last_name |
lead.email |
|
| Phone | lead.phone |
| State | lead.state |
| Calculator | lead.calculator |
| Source URL | source.page_url |
5
Activate
Test the Google Sheets action. Publish the Zap after the test row appears in your sheet.
Was this page helpful?