Setting Up Google Sheets
Step-by-step guide to automatically sending form submissions to a Google Sheet.
What you need
- A Google account
- A Business plan on Make Page
Step 1: Create a Google Sheet
Go to Google Sheets
Open sheets.google.com and create a new blank spreadsheet.
Add a header row (optional)
In the first row, add column headers that match your form fields. For example: Timestamp, Name, Email, Message. The first column is always a UTC timestamp added automatically by Make Page.
Adding headers is optional but recommended — it makes the data easier to read. Make Page always appends below the last row with data.
Step 2: Share the sheet with Make Page
Click Share
In your Google Sheet, click the Share button in the top-right corner.
Add the Make Page service account
In the "Add people" field, paste the service account email shown in your Make Page integration settings. It looks like [email protected].
Set permission to Editor
Make sure the role is set to Editor (not Viewer). This allows Make Page to append rows to the sheet.
Send the invite
Click Send. You can uncheck "Notify people" since the service account won't read the notification email.
If you skip this step, form submissions won't be written to the sheet. The service account needs explicit Editor access.
Step 3: Configure in Make Page
Open site settings
Go to your dashboard and click the gear icon on your site card.
Go to Forms & Integrations
Open the Forms & Integrations tab.
Expand Google Sheets
Click on the Google Sheets card to expand its settings. You'll see the service account email with a copy button — use this in Step 2 if you haven't already.
Paste the spreadsheet URL
Copy the full URL from your browser's address bar when viewing the Google Sheet and paste it into the Spreadsheet URL or ID field. The spreadsheet ID is extracted automatically.
Set the sheet name
If your tab is named something other than "Sheet1", update the Sheet Name field to match.
Enable and save
Toggle the integration on and click Save.
Step 4: Test it
Submit a form on your published site
Open your published site and fill out a form with test data.
Check your Google Sheet
Open the Google Sheet. A new row should appear within a few seconds with a timestamp in the first column followed by the form field values.
Row format
Each form submission adds one row:
| Column A | Column B | Column C | ... | |----------|----------|----------|-----| | Timestamp (UTC) | First form field | Second form field | ... |
The timestamp is in ISO 8601 format (e.g. 2026-03-27T14:30:00+00:00). Form fields appear in the order they are submitted.
Troubleshooting
Row not appearing in the sheet
- Make sure the sheet is shared with the service account email as Editor (not Viewer)
- Verify you pasted the correct spreadsheet URL or ID
- Check that the integration is toggled on and saved
Data appearing in the wrong sheet tab
- The Sheet Name field must match the exact tab name in your spreadsheet. The default is "Sheet1" — if you renamed the tab, update it in settings.
"Not configured" shown instead of a service account email
- The Google Sheets integration hasn't been set up on the server yet. Contact support if you see this on a production site.