・
If the following display appears, the template copy was successful.
1. First, click on "When a row is updated" at the top.
2. You can set the title freely.
Enter the account information to link with Google Sheets.
Select "When a row is updated" as the trigger.
Once you have finished entering, click "Next".
3. Set each item.
The trigger activation interval can be selected from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
※ Please note that the shortest activation interval varies depending on the plan.
For Spreadsheet ID and Sheet ID, click the input field to display suggestions and select from them.
Specify any table range you like.
Once the settings are complete, click "Test" and if there are no issues, click "Save".
1. Finally, click the "Update Employee" icon.
2. Enter the account information to link with BambooHR.
Select "Update Employee" as the action.
Once you have finished entering, click "Next".
3. Enter each item.
When you click the input field, the output obtained earlier will be displayed, so please use it as needed.
Once the settings are complete, click "Test" and if there are no issues, click "Save".
4. With this, the flow of [Updating BambooHR employee information when a row is updated in Google Sheets] is complete.
Once the setup is complete, a screen like the following will be displayed.
Click the "Turn on Trigger" button to activate the flow bot.
With Yoom, you can easily use it without specialized knowledge.
Try this convenient flow from the link below.
There are many other examples of automation using Google Sheets and BambooHR in Yoom, so here are a few introductions.
1. This is a flow where employee information is added to BambooHR when a row is added in Google Sheets.
In the flow introduced this time, we presented a flow where BambooHR is updated when a row is updated.
On the other hand, by using this template, you can add employee information when a new row is added in Google Sheets.
By automating registration, it becomes easier to prevent errors that tend to occur with manual work and to ensure the accuracy and consistency of the data handled within the team.
2. This is a flow to create a meeting space in Google Meet when a row is added in Google Sheets.
By using this template, a meeting space in Google Meet will be automatically created when a row is added in Google Sheets.
This will help reduce the time needed for meeting preparation, allowing you to proceed with your work more efficiently.
3. This is a flow to notify Slack when a row is updated in Google Sheets.
If you want to receive notifications when information in Google Sheets is updated, this template is recommended.
When information in Google Sheets is updated, you can automatically send a notification to Slack based on that content.
By integrating Google Sheets with BambooHR, any updates made in Google Sheets will automatically reflect in BambooHR.
Automating the update process eliminates the need for manual data entry, aiming to enhance overall business performance.
Even those who are concerned about their technical knowledge can easily start automating tasks with Yoom.
No programming skills are required; simply choose a template to efficiently automate time-consuming and routine tasks.
Why not use Yoom to make your daily tasks run more smoothly?