How to setup an editable Google sheet and use the Chronoforms8 Google Sheets write action to add values to it
This is how your Google Sheets write action should look like in order for it to save the data to Google Sheets:
1- The Sheet ID can be found in the browser's address bar when you open your Sheet:
Next, the sheet must be shared with Everyone with a link or with a Google Console account (will be explained later**):
This is how it should be if you share wit ha Console account, the 2nd user should be created in the Google Console:
2- At the bottom you will find the Sheet Name:
In your Google Console, choose a project and search for Google Sheets API:
On the Google Sheets API page, Enable the service in your project or make sure it's already enabled:
Back to the Search page, type "service accounts" and choose the Service Accounts page:
Create a new service account or use an existing one:
Open the new created account page and go under Keys then click "Add Key" then "Create new key":
In the popup window choose JSON:
A JSON file will be downloaded, you will need to upload it to your web server, and use the path as in #3, my file was under the website's root and so we could use {path:root}/file-name
4- Finally you will need to provide the values of the row you want to insert, with the setup we have, the following row has been saved:
**if you need to share the sheet with the new create console account only instead of sharing it with anyone with the link then you need to copy the newly created account address to your Share dialog as shown earlier:
