Connect with Google Sheets

Aliveforms allows to easily connect forms with Google Sheets by integrating Google Sheets to store form submission data in Google Sheets.

Prerequisite

Connection of platform Google created.Learn How to Create Google Connection in Aliveforms
If using service account in connection then sheet in Google Sheets created and the link of Google Sheet. Also, service account should have Google Sheets API and Google Drive API enabled and email address must have editor access to sheet.

To create new Google Sheets integration in Aliveforms, Either click on New Integration from dashboard or browse Integrations and click New button.

In Aliveforms Integration Editor, Google Sheets integration setup requires

Start by selecting connection from dropdown. If you have not created one, create new.

If connection is authenticated with Oauth, click on Load to load list of sheets. Note that it will load sheets only those are created within Aliveforms.
If your sheet is not in list or connection is authenticated with service account, obtain and paste the id of sheet.
You can obtain Google Sheets ID by opening the sheet in browser and copy the address of it. It will be in following format.

https://docs.google.com/spreadsheets/d/yyyyyyyyyyyyyyyyyyyyyyyyyyyy/edit#gid=xxxxxx

It is the purpose of integration. It can be one of these

Note

Note that in case of write and read, first data is written and then read from range provided in range text box.

If mode is set to read or write and read, range of cells is required to read data from in form of SHEETNAME!START:END Here is example:

Sheet1!F1:F4

This is the name of sheet. Select a Google Sheets sheet id first and click on load below Sheet Name dropdown.

Click on Save icon to save the integration data.