How to Utilise the Google Sheet Update Action
Strive Guide
41 steps
4 minutes
Strive
1
Navigate to [https://strive.asia/flowbuilder](https://strive.asia/flowbuilder)
2
Click "Create Flow"
3
Setup the Workflow Trigger as needed.
4
Example if you want keyword then remain as keyword based, input the keyword then click "Add ..."
5
Select the channel that you want to configure the flowbuilder.
6
Click "Add a new flowbuilder step"
7
Click "Text & Image"
8
Input the text that you want to send.
9
Click "Save Action"
10
Click here, drag out then let go to create another step
11
Search or scroll down then click "Wait For Reply"
12
Click "Save Action"
13
Click here, drag out then let go to create another step
14
Search or scroll down then click "Google Sheet"
15
Ensure that you add the stated email as editor then paste the sheet ID.
16
Select the "Append to new row" option.
17
Click "Fetch column headers"
18
Select the sheet tab
19
Select the value that you want to add into the Google Sheet.
20
Example if you want to send value of a variable then click on the tag icon then select the variable.
21
Example "default_name"
22
Default_contact is the phone number or number ID of the contact which triggered the flow.
23
We would suggest to have a column for the phone number/default contact/sender ID column so that it can be the lookup value to check if the row exists in order to update the value in Update Row action later.
24
Click "Save Action"
25
Click here, drag out then let go to create another step
26
Click "WA API Quick Reply"
27
Setup the node as needed.
28
Click "Save Action"
29
Click here, drag out then let go to create another step
30
Search or scroll down then click "Google Sheet"
31
Paste your Sheet ID
32
Select the "Update row" option.
33
Click "Fetch column headers"
34
Select the Sheet Tab if needed.
35
Select the lookup column. Example: There is Sender ID column added into GSheet which will be used to check if the row exists.
36
Click on the tag icon then click "default_contact".
37
Fill in the variable/value that you want to update into the GSheet. For those which you don't want to update then leave it blank/empty.
38
Click "Save Action"
39
Click this icon to rename the flow.
40
Click "Save"
41
Click on the toggle to publish the flow.
How to Utilise the Google Sheet Update Action
Strive Guide
41 steps
4 minutes
Strive
1
Navigate to [https://strive.asia/flowbuilder](https://strive.asia/flowbuilder)
2
Click "Create Flow"
3
Setup the Workflow Trigger as needed.
4
Example if you want keyword then remain as keyword based, input the keyword then click "Add ..."
5
Select the channel that you want to configure the flowbuilder.
6
Click "Add a new flowbuilder step"
7
Click "Text & Image"
8
Input the text that you want to send.
9
Click "Save Action"
10
Click here, drag out then let go to create another step
11
Search or scroll down then click "Wait For Reply"
12
Click "Save Action"
13
Click here, drag out then let go to create another step
14
Search or scroll down then click "Google Sheet"
15
Ensure that you add the stated email as editor then paste the sheet ID.
16
Select the "Append to new row" option.
17
Click "Fetch column headers"
18
Select the sheet tab
19
Select the value that you want to add into the Google Sheet.
20
Example if you want to send value of a variable then click on the tag icon then select the variable.
21
Example "default_name"
22
Default_contact is the phone number or number ID of the contact which triggered the flow.
23
We would suggest to have a column for the phone number/default contact/sender ID column so that it can be the lookup value to check if the row exists in order to update the value in Update Row action later.
24
Click "Save Action"
25
Click here, drag out then let go to create another step
26
Click "WA API Quick Reply"
27
Setup the node as needed.
28
Click "Save Action"
29
Click here, drag out then let go to create another step
30
Search or scroll down then click "Google Sheet"
31
Paste your Sheet ID
32
Select the "Update row" option.
33
Click "Fetch column headers"
34
Select the Sheet Tab if needed.
35
Select the lookup column. Example: There is Sender ID column added into GSheet which will be used to check if the row exists.
36
Click on the tag icon then click "default_contact".
37
Fill in the variable/value that you want to update into the GSheet. For those which you don't want to update then leave it blank/empty.
38
Click "Save Action"
39
Click this icon to rename the flow.
40
Click "Save"
41
Click on the toggle to publish the flow.
