Airtable・Googleカレンダー・Gmailの連携イメージ
How to Integrate Applications

2024/12/10

How to register customer meeting schedules from Airtable to Google Calendar and send meeting URLs via Gmail

m.wadazumi

It is natural to want to manage meeting schedules and handle customer interactions smoothly without any mistakes. When managing schedules manually, the likelihood of errors increases. A solution to this problem is to automate the process by automatically registering meeting schedules with customers from Airtable to Google Calendar and sending meeting URLs via Gmail. This will free you from the hassle of manually registering meeting schedules and notifying via Gmail, allowing you to focus on project management and customer interactions. Recommended for: - Those who are using Airtable and Google Calendar separately and feel challenges in integration - Those who manually notify meeting schedules with customers and want to reduce effort and errors - Those aiming to improve the speed of customer interactions Benefits and Examples of Integrating Airtable, Google Calendar, and Gmail Benefit 1: Reduce the workload of the person in charge Managing meeting schedules can be considered one of the tasks prone to effort and human error. For example, automating the flow of managing meeting schedules in Airtable, registering that data in Google Calendar, and sending it via Gmail can resolve such issues. Additionally, using Gmail to send meeting URLs can reduce the risk of misdelivery or omission. This will lighten the administrative burden on the person in charge, allowing them to focus on new projects and customer interactions. This automation is especially recommended when there are frequent meetings or many meetings to manage. Benefit 2: Strengthen communication with customers What is important in customer interactions is to communicate accurately. For example, if creating meeting URLs or confirming meeting details is done manually, it can take time and delay customer interactions. However, by implementing automation, when meeting information is registered in Airtable, data can be quickly sent to customers using Google Calendar and Gmail, increasing efficiency. This may allow customers to communicate appropriately without feeling distrust due to delays in contact or response. Moreover, interactions with customers can be minimized, reducing unnecessary exchanges. Benefit 3: Standardize responses Many companies with a small number of employees handle customer interactions without assigning specific personnel. In such cases, variations in content and message format can occur, increasing the likelihood of misunderstandings. By automating the registration and sending of meeting data, standardized messages can be sent. For example, by simply registering meeting information in Airtable, the meeting date and time are registered in Google Calendar and automatically sent via Gmail, ensuring the same message is sent regardless of who registers the meeting. This allows customers to receive standardized messages, preventing misunderstandings. We will introduce the automation method using Yoom by integrating Airtable, Google Calendar, and Gmail. [What is Yoom] How to Create an Integration Flow for Airtable, Google Calendar, and Gmail This time, we will introduce how to set up the following template: "Register meeting schedules with customers from Airtable to Google Calendar and send meeting URLs via Gmail." Using this template is convenient as it eliminates the need to set up automation from scratch.
The integration flow is broadly divided into the following processes: - Register Airtable, Google Calendar, and Gmail as My Apps - Copy the template - Set the trigger for Airtable, which serves as the starting point of the flow, and configure the subsequent operations for Google Calendar and Gmail - Turn on the trigger button and verify the integration between Airtable and Gmail If you are not using Yoom, please register for free from here. If you are already using Yoom, please log in. Step 1: Register Airtable, Google Calendar, and Gmail as My Apps Please register Airtable, Google Calendar, and Gmail as My Apps to connect them to Yoom. By registering My Apps first, you can smoothly set up automation. First, register Airtable as My App. Click "My Apps" → "New Connection" on the left side of the Yoom screen. The following screen will be displayed, so please search for Airtable (OAuth) from the app list or search by "App Name." Please check here to register My Apps. When the following screen is displayed, click "Add Base" → "Allow Access" in order. Next, register Google Calendar as My App. Search for Google Calendar in the same way as before or find it from the list. When the following screen is displayed, please log in to Google Calendar. Next, register Gmail as My App, so select Gmail in the previous steps. When the following screen is displayed, log in to Gmail. If Airtable, Google Calendar, and Gmail are displayed in My Apps, the registration is complete. Step 2: Copy the Template To set up automation, please click "Try it" on the banner below.

Read the following screen display and click "OK".

The following screen will be displayed, so check the "Title" and "Description".
If changes are needed, make them from the screen below.
To set up the Yoom flow bot from the extension with the Airtable web page open, click "Launch from Record Detail Page".

Step 3: Setting the Airtable Trigger as the Starting Point of the Flow and Subsequent Google Calendar and Gmail Operations

When the following screen is displayed, check the setup method.
For the trigger setup method using the Chrome extension, check here.
If you haven't installed the Chrome extension, please install it from here.

Scroll to check the settings.

  • "Title" → Can be changed as desired
  • "Account Information for Integration with Airtable (OAuth)" → Check for discrepancies
  • "Action When Launched from Extension" → Launch from Record Detail Page

Check the following setup method.

Scroll and set the following items.

  • "Base ID", "Table ID" → Obtain from Airtable URL
  • "Sample URL of Launch Page" → Set the URL of the relevant page

Once set, click "Test" → "Test Successful" → "Save".

Next, to set up Google Calendar, click "Create Event".
The following screen will be displayed, so check the settings.

  • "Title" → Can be changed as desired
  • "Account Information for Integration with Google Calendar" → Check for discrepancies
  • "Action" → Create Event

When the following screen is displayed, select the "Calendar ID" from the options.
Click inside the box to display options, and select the relevant Calendar ID.

Scroll and set the "Event Title".
By adding the output from "Launch from Record Detail Page", the title will be automatically generated.
The output can be displayed by clicking the arrow within the red frame.
As an example, it was set as follows.

Use the output to set other items as well.
Once set, click "Test" → "Test Successful" → "Save".

Next, to set up Gmail, click "Send Email".
When the following screen is displayed, check the settings.

  • "Title" → Can be changed as desired
  • "Account Information for Integration with Gmail" → Check for discrepancies

Scroll to set the email content, and set "To".
Use the output from "Launch from Record Detail Page" for the setup.

Set the "Subject" as desired.

Finally, set the "Body".
Use the outputs from the record detail page launch and Google Calendar for the setup.
As an example, it was created as follows, so refer to it for your setup.
Once set, click "Next".

The following screen will be displayed, so check the "Email Content".
If there are no mistakes, click "Test" → "Test Successful" → "Save".

__wf_reserved_inherit

Step 4: Turn ON the Trigger Button and Check the Integration Operation between Airtable and Gmail

Finally, click "Turn ON Trigger" to complete the automation setup.
Check if the flow bot is operating correctly.

Here is the template used this time.

Other Automation Examples Using Airtable, Google Calendar, and Gmail

1. This is a flow that automatically registers inquiries received in Gmail to Airtable.
When you receive an email that matches specific keywords, data is automatically extracted and added to Airtable, making it easier to manage inquiries.
By eliminating manual work, you can prevent missed responses or oversights.

2. This is a flow to automatically register events in Google Calendar using information registered in Airtable.
It is recommended automation for those who use Airtable and Google Calendar for schedule management.
Since the event information in Airtable and Google Calendar is synchronized, centralized management becomes possible.

3. This is a flow where when an interview appointment is made in Gmail, the information is automatically added to a Google Spreadsheet and scheduled in Google Calendar.
Automating the registration of interview appointments saves the hassle of manual work.
By recording the details of the interviewee in the Google Spreadsheet, you can keep it as a record.

Summary

By utilizing automation for managing meeting schedules, you may be able to simplify complex administrative tasks.
If automation is set up properly, you can centralize everything from schedule registration to notifications, minimizing errors in notifications and double bookings.
Moreover, communication with clients will be enhanced, allowing for smoother business operations.
This automation is especially recommended for those who feel challenged by efficiency and reliability improvements.

Consider implementing Yoom's automation to make routine tasks a bit easier.

The person who wrote this article
m.wadazumi
I've been working as a writer since my job in child welfare, and I'm currently writing a blog on Yoom. While being surprised by the work efficiency improvements that can be made with Yoom, I would like to share that excitement with everyone and contribute to society. I'll tell you about application integration and automation that even I, who has zero programming knowledge, can do.
Tags
Integration
Automatic
Automation
Notification
Airtable
Google Calendar
Gmail
What is Yoom hyperautomation?
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated.
With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Don't Just Connect Apps—Automate Everything
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.

Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
Learn more about Yoom
Helpful Materials
I understand Yoom! 3-piece set of materials
Download materials
Understand in 3 minutes! Yoom service introduction materials
Download materials
Find out by Before After! Yoom Case Study Collection
Download materials
See a list of useful materials