📝 Overview
This guide will walk you through how to set up a Flowbot to trigger on the last [●] day of each month. The configuration uses schedule triggers and functions to identify the last occurrence of a specific weekday. (e.g., the last Monday of the month)
Refer to the image below for an overview of the Flowbot settings, and we'll explain each step in detail!
☝️ Preparation
Before you begin, you will need a Google Sheets.
You will use functions to calculate the "last weekday of the month" and associate it with the date for the weekday.
Here's an example of how to set up the necessary functions (make sure to include the relevant weekdays).
A | B | C |
Date of the last [●] weekday | [●] weekday | For updates |
=WORKDAY.INTL(EOMONTH(TODAY(),0)-7,1,"1111110") | =TEXT(A2,"ddd") | ● |
=WORKDAY.INTL(EOMONTH(TODAY(),0)-7,1,"0111111") | =TEXT(A3,"ddd") |
|
=WORKDAY.INTL(EOMONTH(TODAY(),0)-7,1,"1011111") | =TEXT(A4,"ddd") |
|
=WORKDAY.INTL(EOMONTH(TODAY(),0)-7,1,"1101111") | =TEXT(A5,"ddd") |
|
=WORKDAY.INTL(EOMONTH(TODAY(),0)-7,1,"1110111") | =TEXT(A6,"ddd") |
|
=WORKDAY.INTL(EOMONTH(TODAY(),0)-7,1,"1111011") | =TEXT(A7,"ddd") |
|
=WORKDAY.INTL(EOMONTH(TODAY(),0)-7,1,"1111101") | =TEXT(A8,"ddd") |
|
🛠️ Set Up the Flowbot
① Schedule Trigger
Use “cron” settings to configure the Flowbot on the last [●] weekday of each month.
For the last [Monday], set the cron schedule as follows:
Monday (10:00 AM) on or after the 4th week of each month:
0 10 22-31 1-12 1
Similarly, for the other weekdays, adjust the number at the end.
Sunday | 0 10 22-31 1-12 0 |
Monday | 0 10 22-31 1-12 1 |
Tuesday | 0 10 22-31 1-12 2 |
Wednesday | 0 10 22-31 1-12 3 |
Thursday | 0 10 22-31 1-12 4 |
Friday | 0 10 22-31 1-12 5 |
Saturday | 0 10 22-31 1-12 6 |
👉 For detailed instructions on setting up a schedule trigger, refer to this guide!
② Entering Values into Google Sheets
Link the Google Sheets with Yoom, and use the action Input values into cells to set “●” in cell C2.
Specify the Spreadsheet ID, Sheet Name, and Target Cell to the Google Sheets you prepared in the preparation step.
The value can be any text or number you choose.
☝️ Note:
If you update the spreadsheet, the dates will refresh automatically.
👉 For detailed instructions on how to connect Yoom with apps, refer to this guide!
③ Database Set Up
In this step, configure the action to retrieve record in Google Sheets based on the desired weekday.
Specify the fields under the database connection to the Google Sheets you prepared in preparation step.
Use the search value to get the last date that matches the weekday.
Under Advanced Settings, Turn OFF the Handling of Search Failures. When the search fails, ensure the Flowbot can continue if there are no matches.
④ Branch Set Up
In the Branch action, set it so that if the date obtained in step 3 matches today's date, it will proceed with the next steps.
If today's date is not the last [●] weekday, the Flowbot will end.
If it is the last [●] weekday, the Flowbot will continue as expected.
👉 For detailed instructions on how to connect Yoom with apps, refer to this guide!
📚 Related Guides
📅 How to Set Up Schedule Triggers - View Guide Here
⏳ How to Configure Cron Jobs - View Guide Here
🔗 How to Set Up "Connect with Apps" - View Guide Here
How to Set Up Branching - View Guide Here
Related Keywords
Related Keywords
Flowbot, Cron, Schedule Trigger, Yoom, Weekday, Last Day, Scheduling, Google Sheets, Workflow, Automation, Database Actions, Branch, Date Handling, Task Scheduling, Weekday Calculation