How do I set it up?

→ Go to the BIK flow builder and on the side menu, open the ‘Action’ blocks.

→ Scroll down to the Google sheets blocks where you’ll see the below actions 👇

You can take 3 key actions:

→ Add a row

→ Update a row

→ Get row data

Add a row

Give editor access to [email protected]
Select “Add row data” from the actions on the side panel
Copy and paste your sheet’s URL onto the Sheet URL input field
In the body section, in “Key” input field, enter the header or column name under which you want to push data
In the body section, in “Value” input field, enter the value you want to push (this can be a variable as well)

Give editor access to [email protected]
Select “Update row data” from the actions on the side panel
Copy and paste your sheet’s URL onto the Sheet URL input field
Add the Lookup column.
💡 the lookup column is the column where we will find the lookup value you want to update the row against
Add the Lookup value
💡 this value is the value you want to look up in the above mentioned column
Add the Destination column
💡 the destination column will find the column you want to update
Add the Update value
💡 this value will be pushed to the destination column of the row where the lookup value is

Give editor access to [email protected]
Select “Get row data” from the actions on the side panel
Copy and paste your sheet’s URL onto the Sheet URL input field
Add the Lookup column
💡 the lookup column is the column where we will find the lookup value you want to fetch
Add the Lookup value
💡 this value is the value you want to look up in the above mentioned column
Save the column names that you want to fetch data for against the lookup value
You can use these values in the flow later!
- find it under “Api data responses” (open this toggle to see where)

Data is not getting pulled/pushed. What can I do?

Ensure that the sheet ID added to the block is correct. You can find the spreadsheet ID in a Google Sheets URL: https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=0
Ensure that you have given editor access to this email ID: [email protected]
Ensure that you are not passing data to a “hidden” column
Ensure that the sheet is not "hidden"
If you have multiple sheets inside a spreadsheet please make sure that the primary sheet where you want to data push/read operations is in the first index (you can drag and change the index of sheets).

How can I trigger flows when new rows are added to a sheet?

This is not possible currently. You can request this as a feature request via your GSM or write to us at [email protected]

Best practices