automate-lead-capture-from-google-forms-to-google-sheetslisted
Install: claude install-skill zapier/awesome-zaps
# Automated Lead Capture and Follow-Up
The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/automate-lead-capture-from-google-forms-to-google-sheets. Read the files there if this skill was installed on its own.
## What it does
1. **Trigger:** a new response is submitted to the lead form (`google-forms`, `new_form_response`).
2. **Google Sheets** logs the lead to the CRM worksheet with its submission time, name, email, phone, company, lead source, status `New Lead`, score `Cold`, and a follow-up date 24 hours out.
3. **Gmail** sends the lead a personalized welcome email with a booking link.
4. **Google Calendar** creates a follow-up reminder for the team at the follow-up time.
5. **Gmail** sends the sales team member a summary of the lead.
If a submission has no name or no email, the Zap logs it to the Incomplete Leads tab and stops there, so no welcome email goes out.
If one action fails, the Zap records the error and runs the rest, so a single failure doesn't lose the lead.
## Ask the user
Each `REPLACE_…` value is set per person. Resolve names to IDs with the user's own connections; don't ask them to paste an ID you can look up.
| Setting | Where | What goes there |
| ---------------------------------------------------------------- | --------------------