All you need to connect Google Sheets to Niro is a Google Account. If you don't already have one, set up a Google account here – it's free!
Note: Each flow can be integrated with one Google sheet – in other words, you can’t integrate the same flow with multiple Google Sheets.
1 Go to the Integration page and select the Google Sheets response handler.
2 In the next step, create a new Google Sheet as usual.
3 To enable your flow to access the sheet and add responses to it you have to share edit rights with the following email address: [email protected]. Save your settings and agree on sharing the rights with Niro.
Google might get asked if you really want to share your sheet with Niro. Please agree and don't worry: Niro will only have access rights to this particular Google Sheet and will only use access rights to insert your data and nothing else.
4 Next, copy the Spreadsheet ID from the URL and Sheet ID from the bottom of your sheet to the predefined input fields in your Niro flow's integration page.
Spreadsheet ID: Copy everything between spreadsheet/d/ and /edit e.g.,
docs.google.com/spreadsheets/d/[Your Spreadsheet ID]/edit
Sheet ID: You can find the Sheet ID at the bottom of your sheet.
5 You are almost done! Just make sure you copied the right Spreadsheet ID and Sheet ID into the input fields and click Save.