If you are using Yoom, please log in. If you are new, please
register as a member.
If you proceed as it is, the template will be automatically copied to your workspace.
Please change the template name as needed.
Click on My Projects on the left to display the template you just copied.
Click the ellipsis (...) on the right and select Edit.
Items to prepare
A Google Spreadsheet with employee information registered.
Please refer to the image for the header.
Now, let's set up the app trigger.
Select "
When a row is updated".
Please change the title as you like.
After confirming the account information to be linked, proceed to the next step.
Please enter the required items.
Trigger activation interval: You can choose from intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
*The selection of activation intervals varies depending on the plan.
Set the table range to include everything, including the header.
Column with unique values
*Be sure to select a column where values do not overlap!
Here, move to Google Spreadsheet and update the record.
This time, I changed the phone number and entered
Update in the update judgment column.
(Because it is set in the column where you want to detect updates)
Return to Flowbot and test.
Save when the record information from Google Spreadsheet is reflected in the output.
Next, click "
Update Contact".
Please also check the account information to be linked.
Proceed to the next step and set the items.
Select from the output as shown below.
Please set other items as needed.
Test this as well, and save if successful.
Thank you for your hard work so far.
Even I, who am not familiar with programming, was able to proceed easily.
Here is the Flowbot used this time ↓