Skip to content
OneForm
Start free
View as Markdown

Connect Google Sheets

Add a row to a Google Sheet for every response, or keep a sheet of your leads with their scores.

Basic plan and upAdmins and ownersUpdated October 22, 2026 · 2 min read
Connect Google Sheets ↗

Google Sheets gives you a running log of every response, in a spreadsheet you can sort, share and chart. You can also keep a sheet of your leads, one row per person, with their lead score.

Connect Google Sheets

The Google Sheets panel on the Integrations page, with the Connect Google button

  1. Go to Integrations. The Google Sheets panel opens.
  2. Click Connect Google.
  3. Choose your Google account and allow the access Google asks for.
  4. You're back in OneForm, and the Google account is connected.

If your Google account is already connected for something else, click Allow next to Sheets on its card instead.

Log every response

  1. Open Workflows and open the workflow you want, or start one from the Log every response to Google Sheets recipe.
  2. Click + (Add an action) and choose Add a row in Google Sheets.
  3. Under Google account, choose the account.
  4. Click Create a new spreadsheet, or Choose from Google Drive to use one you have.
  5. Type the Tab name. OneForm creates the tab if it doesn't exist.
  6. Under Columns, keep Every answer, or pick Choose columns and set each column's value.
  7. Click Test it, then Turn on (or Save and turn on).

With Every answer, each row has the date, name, email, one column per question, scores, the report status and a review link. When you add a question to the form, OneForm adds a column for it.

Keep a lead list

  • From a workflow: add Keep a lead list in Google Sheets and choose Which leads: Everyone, Warm & hot or Hot only.
  • From the Leads page: click Export, then the Google Sheets entry under Send to your CRM or a sheet. The first time, pick or create the sheet.

Each lead gets one row, and sending them again updates that row instead of adding another. See Send leads to your CRM.

What OneForm can see

Only the spreadsheets OneForm creates and the ones you pick in Google's file picker. It can't open anything else in your Drive. The access is stored encrypted.

Disconnect Google Sheets

On the Integrations page, click Manage on the Google card, then Disconnect. This removes the whole Google account, so Drive, Calendar and Chat stop working for it too. OneForm also gives up its access in your Google account, unless another OneForm firm still uses that account. Your spreadsheets stay in your Drive.

Why can't I find my existing spreadsheet?

OneForm can only use a sheet you choose in Google's picker. Click Choose from Google Drive and pick it there, from the same Google account you connected.

Why did rows stop arriving?

  • The spreadsheet was deleted, or the connected account lost access to it. Choose the sheet again in the action.
  • Google access was removed or expired. The Google card moves to Needs attention; click Reconnect.

See An app stopped sending.

Was this article helpful?
Connect OneForm to your other appsHow the Integrations page works, how one-click connecting works, which apps your plan includes, and how to disconnect.Basic plan and upConnect Microsoft ExcelAdd a row to an Excel workbook in your OneDrive for every response, or keep a workbook of your leads with their scores.Basic plan and upConnect Google DriveSave every report PDF into a Google Drive folder, with a sub-folder per client if you like, or send finished reports in one go.Pro plan and upResponses and leadsSend leads to your CRMSend people from the Leads page to HubSpot, Salesforce, Pipedrive, Zoho CRM, Google Sheets or Excel, with their score and why.Pro plan and up