Skip to content

Send ClarNow responses to Google Sheets

The Google Sheets integration adds every new response to a spreadsheet as a row, with one column per question. Sort, filter, chart or share the answers in the tool your team already knows.

  • One row per response, added at the bottom of the sheet as soon as the respondent submits.
  • One column per question, in the order of the form, with the question titles as headers. The first column, Submitted at, holds the date and time in UTC.
  • Readable answers. Choices, phone numbers and the like are written as you see them in ClarNow, not as raw IDs. Dates and times are written in a sortable form, such as 2026-08-01.
  • Plain values. Nothing an answer contains can turn into a formula.

Data goes one way, from ClarNow to Google Sheets. Editing or deleting a row in the sheet does not change anything in ClarNow.

  • A ClarNow account on any plan, including Free.
  • Edit access to the form you want to connect.
  • A Google account — personal or Google Workspace — and a spreadsheet to write to. ClarNow writes to an existing spreadsheet, so create one in Google Sheets first if you need a new one. If your Workspace only allows approved apps, your admin may need to allow ClarNow.
  1. Open the form in the ClarNow builder and go to Connect → Integrations, then click Google Sheets under Data.

  2. Click “Connect Google Sheets”. ClarNow sends you to Google. Choose the account, review the access — ClarNow can only use files you pick or that it creates — and click Continue.

  3. Pick the spreadsheet. Back in ClarNow, click Select spreadsheet under Spreadsheet. Google’s file picker opens; choose the spreadsheet.

  4. Pick the sheet — the tab inside the spreadsheet — under Sheet.

  5. Click Save. ClarNow writes the column headers into the first row of that sheet. The next response will appear below them. You don’t need to republish the form.

The columns are fixed when you click Save, so editing the form never shifts rows that are already in the sheet.

  • New question: it gets no column until you open the Google Sheets panel and click Save again, which rewrites the header row. Rows already in the sheet are not moved — if the new question isn’t the last one, pick a new sheet tab before saving so the old and new rows stay lined up.
  • Deleted question: its column stays, and new rows leave that cell empty.
  • Renamed question: the header keeps the old title until you save again.
What Where it goes Why
Submission time and every answer of the response The sheet you picked The row itself

Access ClarNow asks for in Google: drive.file only — read and write the spreadsheet you pick in Google’s picker. No access to the rest of your Drive.

What ClarNow stores about the connection: a Google refresh token, the spreadsheet’s ID and name, the sheet’s name and the column order. It is used only to add rows, and is deleted when you disconnect, permanently delete the form, or close your ClarNow account. Details are in the Privacy Policy.

  1. Open the form → Connect → Integrations → Google Sheets.

  2. Click Disconnect Google Sheets.

What changes: ClarNow deletes its Google token and spreadsheet settings for the form, and adds no more rows. Other forms connected to Sheets keep working.

What stays: the spreadsheet and every row already in it.

  1. Go to your Google Account → Security → Your connections to third-party apps & services (or open myaccount.google.com/connections).

  2. Open ClarNow and click Delete all connections you have with ClarNow.

What changes: ClarNow loses access at once, for every form you connected with that Google account — including Google Drive, which uses the same access. Responses are still collected in ClarNow.

What stays: your spreadsheets and their rows.

Which ClarNow plan do I need for Google Sheets?

Any plan, including Free.

Can ClarNow see my other spreadsheets?

No. ClarNow asks Google for access to only the files you pick or that it creates itself — the drive.file permission. It can write to the spreadsheet you chose in Google's picker and nothing else in your Drive.

Are responses I already have added to the sheet?

No. Only responses submitted after you click Save are added. For earlier ones, open the form's results in ClarNow and use Export to CSV, then paste them into the sheet.

I added a question to the form. Why is there no column for it?

The columns are fixed when you click Save. Open the Google Sheets panel and click Save again to write the new header row. Rows already in the sheet are not moved, so if the new question sits in the middle of the form, start a new sheet tab to keep the columns lined up.

Can an answer break my sheet with a formula?

No. Answers are written as plain values, so an answer that starts with “=” stays text and never runs as a formula.

What happens if Google Sheets is down when someone submits?

The response is always saved in ClarNow first, and the row is added after it. If Google does not accept the row, it is not retried; the response stays in ClarNow, where you can see and export it.

Email [email protected] or pick a case on the contact page — no account needed. We reply within two business days, usually within one. See also Support, the Privacy Policy and the Terms of Service.