Set new event in google calendar when new row is added in sheet table

[Marko_Nesic]

Hello guys,

Does anyone have an idea how to set a bot or action that will create new google calendar event, when new row is added to a table(WorkOrder)

1. I have a WorkOrder table with Date column, Time, Description, etc.

2. I have a google calendar integrated in app

Thanks

[AleksiAlkio · Accepted solution]

#1 - Create an action "add a new row to another table using values from this row"
#2 - Trigger the action as the "Event action" from the Form view "WorkOrderForm"
When the WorkOrder is saved, it triggers this action and the new event is added to your gCal. Though you need to create a functionality that it's not triggered when the row is modified. Another option is to trigger this action with a Bot as you can specify is it triggered only with Adds.

[Marko_Nesic]

Thanks!

😀It works perfectly

[AleksiAlkio]

Excellent!