How to Build an AI-Powered Calendar Scheduler Bot | Zapier Central Full Tutorial

Use the power of AI and Zapier to automate tasks for you by building AI-powered bots with Zapier’s new product “Zapier Central”.

THIS IS NOT A SPONSORED VIDEO.

In this video we will build a bot which estimates how long a task will take based on task-duration pairs in a Google Sheet.

The bot is then able to automatically schedule that task on your Google Calendar as a new event with the AI estimated duration.

The bot is also able to add a new row to the sheet automatically when when a new event is added to Google Calendar to “train” the bot to make it smarter at estimating task duration.

⌨️ PROMPTS FOR INSTRUCTIONS:

PROMPT #1:

### Role: You’re an expert at estimating the duration of a specific task then add the task to a Google Calendar.

### Instructions:
Step 1: Estimate the duration (in hours) that a task will take based on existing data using the “Get Many Spreadsheet Rows” action. The ‘Task Name’ will be enclosed in triple quotes (“””). If you’re provided with the ‘Estimated Duration’ by the user, use that duration in Step 2 and ignore the sheet.

Step 2: Add a new event to Google Calendar using “Quick Add Event” action with the duration confirmed in Step 1. If no schedule is given, the event must be added any time during working hours, between 9 AM and 5 PM , Monday to Friday.

PROMPT #2:

When a new event is added to the calendar through the “New Event” trigger, then create a spreadsheet row with the Event name as the ‘Task name’ and the event duration as the ‘Duration (in hours)’.

PROMPT #3:

When an existing event name or duration in the calendar is changed or updated, then you must update the relevant spreadsheet row with the Event name as the ‘Task name’ and the event duration as the ‘Duration (in hours)’.

Check my AI Prompt Engineering course: https://bit.ly/3IVFEE4

📚 RESOURCES
– Zapier Central Home Page: https://zapier.com/central
– #Zapier #Central App: https://central.zapier.com/

⚡ ADDITIONAL ZAPIER RESOURCES
– Data source limitations: https://help.zapier.com/hc/en-us/articles/24569690575117-Add-a-data-source-to-a-Zapier-Central-bot

✅ STEP-BY-STEP GUIDE & TIMESTAMPS:

1:36 Sign up for Zapier Central

2:05 Demo of what we are going to build

6:11 Create new bot

6:30 Connect live data source

9:16 Limitations of live data sources

10:20 Create a new behaviour

13:33 Add user message trigger

14:34 Add Google Calendar Action