Curso Básico de Automação com IA - Aula 6: Criando eventos no Google Agenda de forma automática

Introduction

This tutorial will guide you through automating event scheduling on Google Calendar using Google Sheets and the Make platform. By the end of this process, you will have a system that automatically creates calendar events, sends personalized emails to participants, and updates your spreadsheet to prevent duplication. This automation will save you time and streamline your scheduling tasks.

Step 1: Set Up Your Google Sheets

• Create a new Google Sheets document.

Define the following columns in the first row

• Event Title
• Event Date
• Event Time
• Email Addresses of Participants
• Status (to track if the event was scheduled)

Step 2: Sign Up for Make

• Visit the Make website and create an account if you don’t have one.
• Familiarize yourself with the platform interface.

Step 3: Start Your Scenario in Make

• Click on "Create a new scenario."
• Select Google Sheets and Google Calendar as your applications for this automation.

Step 4: Integrate Google Sheets with Make

• Use the Google Sheets module to connect to your sheet.
• Set it to watch for new rows added to your sheet to trigger the automation.

Step 5: Create Events in Google Calendar

• Add the Google Calendar module to your scenario.

Configure it to create a new event using the data from the Google Sheets columns

• Title: Map to the Event Title column.
• Date and Time: Combine the Event Date and Event Time columns.

Step 6: Avoid Duplicates

• Implement filters in Make to check if the event already exists in your calendar.
• Use the Status column in your Google Sheets to update whether the event has been scheduled.

Step 7: Create Variables in Make

• Define variables that will hold data such as event details and participant emails.
• This will help in managing the information more effectively during the automation process.

Step 8: Use Formulas to Separate Emails

• If multiple emails are listed in a single cell, utilize Make's formula functions to split them.
• Create a new variable that holds the individual email addresses for further processing.

Step 9: Automate Email Notifications

• Add a module in Make to send emails.
• Personalize the email body with details from the event and include the participant emails.
• Ensure you include a clear subject line indicating the event.

Step 10: Update Google Sheets with Status

• After successfully creating the event and sending emails, update the Status column in Google Sheets.
• Change the status to "Scheduled" to prevent reprocessing the same event in the future.

Step 11: Test Your Automation

• Run the scenario to ensure everything is working as intended.
• Add a new row in your Google Sheets with event details and verify that the event is created in Google Calendar and emails are sent.

Conclusion

You've successfully set up an automation system that integrates Google Sheets and Google Calendar using Make. This system will help you manage and schedule events more efficiently. As a next step, consider exploring additional functionalities in Make to further enhance your automation processes or integrate with other applications.