How Google Sheets Sync Works

The sync process

When a visitor submits a form on your website, here’s what happens behind the scenes:

1. 1

   Form submission is captured

   The Lead to Sheet snippet on your website detects the form submission and sends the data to our servers.

2. 2

   Data is stored securely

   The submission is saved in our database with a "Pending" status while it waits to be synced.

3. 3

   Submission is written to your Google Sheet

   Our sync system picks up the pending submission and writes it as a new row in the correct tab of your Google Sheet.

4. 4

   Status is updated

   Once the row is successfully written, the submission’s status changes to "Synced".

What gets synced

Every piece of data captured from the form submission is written to your Google Sheet, including:

• A Lead Quality column (for you to score leads manually)
• The submission date and time (in the submitter’s timezone when available)
• All form field values (name, email, phone, message, etc.)
• The page URL where the form was submitted
• Referrer, UTM parameters, and ad click IDs
• Browser, OS, device type, screen size, language, and timezone

If sync fails

If a submission can’t be written to your Google Sheet (due to a temporary API issue, for example), it’s not lost. Lead to Sheet automatically retries failed submissions up to 5 times with increasing delays. You can also retry manually from your Forms & Leads page.