Google Sheets is a web-based spreadsheet offered by Google as part of their Drive office services. It makes it easy to create, edit and collaborate with others from any device.
Google Sheets can be used as an input and/or an output.
- Create a new worksheet
- Create a new spreadsheet
- Add data (Insert) in an existing worksheet
- Erase and Replace data (Drop) in an existing worksheet
To configure Google Sheets connector:
Give a name to your connector:
Click on Authenticate with Google:
Allow RestApp and its features:
Test the connection and be sure it is successfull:
Click on Remove Access https://myaccount.google.com/permissions to refresh token.
Follow the Setup part from 2 for the next step.