← ClaudeAtlas

automate-lead-capture-from-google-forms-to-google-sheetslisted

Build a Zap on Zapier that logs each new Google Forms lead into a Google Sheets CRM, sends the lead a personalized welcome email with a booking link, creates a 24-hour follow-up reminder on Google Calendar, and alerts the sales team by Gmail. Use when a team wants inbound form leads captured, answered and followed up automatically.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
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 | | ---------------------------------------------------------------- | --------------------