“Anytime a new lead form entry is created in Google Ads, create spreadsheet row in Google Sheets and send email in Gmail.
You must have a Google Sheets created that you map to in the steps. These are the field names that you must put at the top of the sheet before you configure the Zap. Double check with the CSV download you get from Google Ads. The reason why I added a Zapier Timestamp is because the Zap does not bring the captured timestamp we typically see in the CSV so I added one. This Zap is immediate. As soon as the entry is captured, a new row is added to the Google Sheets and an email is sent to the email addresses of choice to notify this. I recommend in the body of email to include a link to the Google Sheet you create.
Google Sheet Column Names. These have tabs in between so if you copy/paste it should work fine. Let me know if you have any questions.
Zapier Timestamp Submit time EDT Gclid Campaign name Ad Group name Full name Email Phone number Would you require more information?”
