How to connect the SiteManager Form to Google Sheets.

This article will explain how to connect the SiteManager form to a Google Sheet. Every time the form will be submitted, a new row will be added to your Google Sheet.

To connect with Google Sheets please install the Google Drive Integration first.
You can find this in the general settings of your project.

* If it's the first time authenticating with Google, you will find only a single button inside the app. By clicking on this button, a new window will be opened where you can log in to Google. We ask for permission to view all your Google Drive files and to view, edit, create and delete your spreadsheets. These permissions are strictly necessary to be able to select a sheet and to write the data to that selected sheet.

After authentication, a confirmation will be shown, so you know you're successfully authenticated. That's all there is to it!

Connecting to Google Sheets

To use the Google Sheets action, it is necessary to authenticate with Google first. We need to know from which account the sheet can be accessed. Luckily, this is a very straightforward setup, so you'll be up and running in no time!

Google Sheets app

When you install the Google Drive integration, the Google Sheets app will be automatically installed in your project. You can find the app in the toolstack section of the project.