Google Sheets
The Google Sheets add-on adds each message of a form to a spreadsheet as a row: the date, a column per field, the page it came from and the entry’s number. A button sends the entries you already have.
Set it up once
The site uses an OAuth client of your own in Google Cloud, so the rows go straight from your site to your Google account.
- In Google Cloud, pick or make a project and turn on the Google Sheets API.
- On the OAuth consent screen, fill in the app’s name and your email, and set the publishing status to In production. Left in Testing, Google signs the site out every 7 days.
- In Credentials, create an OAuth client ID of the Web application type.
- Add the Authorized redirect URI shown in Contact Form → Settings → Integrations → Google Sheets. It ends in
admin-post.php?action=remaily_google_sheets. - Paste the client ID and secret there, save, and click Connect your Google account. Google may warn that it hasn’t checked the app: pick Advanced, then go on. It’s your own app.
The card then says Connected to your Google account, with a Disconnect link.
The form’s Google Sheets tab
| Setting | What it does |
|---|---|
| Spreadsheet | The link of the spreadsheet, copied from the address bar. The connected account must be able to edit it. |
| Sheet | The tab at the bottom of the spreadsheet. Empty: the first one. A name it doesn’t have yet is added. |
| Send saved entries | Sends the form’s saved entries that aren’t in the spreadsheet yet, oldest first, up to 500 a click. Save the form first. |
The first row gets the column names on its own, and a new field adds a column, so you can sort, filter or move columns as you like. Each form can use its own spreadsheet, or several forms one each sheet of the same spreadsheet.
What visitors type goes in as plain text: a value starting with = stays text and never runs as a formula. When a row can’t be added, the card in Settings says why, such as a link to a spreadsheet the account can’t edit.
