I would like to automate the sending of data from a specific row in a specific table to make.com when a certain date and time is reached. The date and time will be contained in a “publish on” column. Upon reaching this date and time, the data for that row will be sent to a scenario in make.com via a make webhook.
The question is: what is the best way to do this?
I imagine a javascript or python script is the way forward, but this is currently beyond my skill level. Help would be much appreciated.
In the meantime, I have managed to create a Python script that sends information to Make when a certain date is reached. I have achieved this by using SeaTable’s Automation to trigger every day at the same time and as action run a Python script that searches rows in a table that match that date and send the results via webhook to Make.
What I would like is to be able to automate it to send at a time that is also set in the “publish on” column rather than the specified automation trigger time.
e.g. 07.03.2025 07:00 in row 1 means it is sent at 7 am on that day
08.03.2025 13:00 in row 2 means it is sent at 1 pm on the 8th.
I would of course like this to run in the background and not have to be triggered manually.
I haven´t tried it, but maybe a second column using if and now formula. if now matches the actual date of your date column the automation gets triggered.
Thanks for your thoughts. My query is about the time and not just the date. Could the “if now” formula also be used to trigger an automation, I wonder which of the 4 types would be the most appropriate? Or could the formula be used to trigger the Python script, because that really would be the most appropriate? Unfortunately, none of the 4 automation rule types offer a “date and time is now” option, so the trigger would need to go to the script (I believe).
Full disclosure: I am not a coder. I used ChatGPT and the SeaTable docs to help me with the python script.
A “date-time column is now” filter does not work in an automation with event “check periodically” because they only check once at the time defined in the rule.
