How to integrate Google Chat with Airtable to add the content of a message sent in Google Chat to Airtable

Step 1: Integrate Google Chat and Airtable with My Apps

First, integrate Google Chat and Airtable with My Apps.
After logging into Yoom, click on "My Apps" on the left side of the screen, then search for and click on Google Chat from "+New Connection".
*Integration with Google Chat is only possible if you have a Google Workspace subscription. For more details, please refer to here.
*If two apps appear in the search results, please click on Google Chat (OAuth).

Next, click on "Sign in with Google".

‍

*The integration with Google Chat (OAuth) is explained here.
Enter "Client ID" and "Client Secret" and click "Register".
This completes the registration of Google Chat with My Apps.

Next, search for Airtable from "+New Connection".

Sign in to Airtable using any method you prefer.

Next, click on "+Add a base" at the bottom of the page and select a workspace.
Then click "Grant access" to complete the Airtable integration.

Next, proceed with the setup using the Flowbot template.
Log in to Yoom and click "Try it" on the banner below.

"Template has been copied!" will be displayed, so click "OK" to complete the copy.

Step 2: Load messages from Google Chat

Next, set up to load messages from Google Chat.
Click "When a new message is posted in the room".

‍

On the next page, check the "Account information to integrate with Google Chat".
The title can be edited, but do not change the trigger action and click "Next".

Set up the API connection.
"Trigger interval" can be selected from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
*Please note that the shortest trigger interval varies depending on the plan.
For "Space resource name", click the input field and select the space from the displayed options.
Once the setup is complete, post a message in the specified space and click "Test".

Check the information displayed in the output and click "Save".

Step 3: Perform data replacement using regular expressions

‍

Next, set up data replacement using regular expressions for the message content.
Click "Perform data replacement using regular expressions".

‍

Click the input field for "Replacement target" and select the message content loaded from Google Chat from the displayed options.
"Specify replacement location with regular expression" can be set optionally. For details on regular expressions, please see this page.
Once the setup is complete, click "Test".

Check the message displayed in the output and click "Save".

Step 4: Save the message to Airtable

Next, set up to save the message to Airtable.
Click "Create record".

Perform optional title editing and account information verification, then click "Next".

Refer to the annotations for "Base ID" and "Table ID or Name", and enter the values obtained from Airtable.
In "Field Information", set "Field Name" and "Value".
For "Field Name", enter the field name set in the Airtable table as shown in the image.
For "Value", click the input field and select "Replaced Value" from the displayed options.

Additionally, click "+ Add Field Information" to add more save items.
If you want to add save items, increase the field items in the Airtable table and specify them with the field name.
When ready, click "Test".

Verify that the message has been added in Airtable and click "Save".

Finally, click "Turn on Trigger" to complete the flow operation preparation. Now, when a message is sent in Google Chat, the post content will be added to Airtable.

Other Automation Examples Using Google Chat

There are many other examples of automation using Google Chat in Yoom, so here are a few to introduce.

1. Notify Google Chat when a lead is created in Microsoft Dynamics365 Sales

Sharing lead creation information from Microsoft Dynamics365 Sales in Google Chat facilitates smooth communication among stakeholders. This is expected to enable a prompt response to leads.

2. Notify Google Chat When a Chat Starts in Chat Plus

By notifying Google Chat of new chats in Chat Plus, team members can more easily stay informed about the situation. This is expected to strengthen the support system.

3. Notify Google Chat When an Order is Placed on B-Cart

By notifying Google Chat of order information from B-Cart, stakeholders can quickly grasp the situation. This is expected to streamline order processing.

Benefits and Examples of Integrating Google Chat with Airtable

Benefit 1: Streamlined Task Management

By automatically registering the content of task-related messages shared in Google Chat into Airtable, you can expect to prevent manual input errors and recording mistakes.
For example, organizing task details, assignees, and deadlines in Airtable can create an environment where everyone accurately understands the current task status.
Additionally, by centrally managing task progress in Airtable, it is anticipated that team collaboration will be strengthened, and it will be easier to prioritize tasks.
This is expected to reduce factors that hinder project progress and contribute to improved work efficiency.

Benefit 2: Organization and Extraction of Specific Information

You can extract specific information from conversations in Google Chat using regular expressions and register it in the appropriate fields in Airtable.
For instance, by organizing data such as email addresses, phone numbers, dates, and URLs based on specific rules, it is expected that important information can be managed accurately.
This will prevent information from being scattered and allow for efficient searching and utilization of necessary data for business operations.
In particular, by automatically managing specific data that frequently appears in messages, the overall business process is expected to be streamlined.

Benefit 3: Enhanced Information Sharing and Transparency Among Teams

Automatically registering the content of messages shared in Google Chat into Airtable supports more efficient information sharing within the team.
Since messages and related data can be managed in Airtable through regular expressions, it is anticipated that any member can easily check the necessary information and understand the progress of individual tasks.
This prevents information omissions and duplicate work, and by advancing tasks based on the same information, transparent project management is expected.
Especially in projects involving large teams or multiple departments, this will be an effective means to facilitate smooth collaboration between teams.

Conclusion

Integrating Google Chat with Airtable supports the efficiency of information sharing and the accuracy of task management.
By automating data entry and sharing tasks that were traditionally done manually, you may save time and create an environment where you can focus on high-priority tasks.
Yoom's app integration can be easily implemented without programming. Take this opportunity to experience improved business efficiency.