When a record is added to the Yoom database synchronized with Google Sheets, it triggers an action to add that information to kintone and then sends a notification to Slack.

No items found.

■Overview

This is a flow where when a row is added to a spreadsheet, the row information is added to kintone, and a notification is sent to Slack.

Spreadsheets cannot be used as triggers, but by connecting data with YoomDB, they can be used as pseudo-triggers.

‍

■Preparation and Precautions

‍・Spreadsheets themselves cannot be used as triggers.

・By connecting the spreadsheet to the Yoom database, this flow can be executed.

‍

‍■Spreadsheet Actually Connected to Data

‍https://docs.google.com/spreadsheets/d/1PipZ5rZJPe9Yf0YZjJ5TPQit7oHLpqIgZsDAE92wbhw/edit#gid=2066627429

‍

‍■Creation Method (Data Connect in Database)

‍① Create a new Yoom database, prepare one table, and perform the following settings.

・Delete Columns: Click on each column name and delete all default columns by selecting delete column.

・Data Connect: Click the data connect button at the top right and select the spreadsheet.

・Execute Action: Select to retrieve the list of records.

・Spreadsheet ID: Select the target spreadsheet from the candidates.

・Sheet Name: Select the target sheet name from the candidates.

・Range: Enter the range of the spreadsheet you want to retrieve from the position of the column name (header) and perform a connection test. (Example: A1:D etc)

・Database Display Items: Select the items of the spreadsheet you want to display in the Yoom database.

・Unique Item: Select the unique column item on the spreadsheet.

・Sync Frequency Setting: Select the desired time manually or automatically.

・Database Trigger Activation Setting: Turn it ON and link.

‍

‍■Creation Method (Flow Bot)

‍① Select the table connected by the database trigger, choose the action "when newly created," and save it.

② From the operation to manipulate the database, select kintone and perform the following settings.

・Action: Select to add a record.

・App ID: Enter the ID of the target kintone app.

・Field Values to Add: Embed the output obtained in ① into the corresponding field values.

※ For settings on embedding output, please refer to the help page. https://intercom.help/yoom/ja/articles/8223528

‍③ From the operation to link with the app, select to send a message to a Slack channel and perform the following settings to save it.

・Channel ID to Post: Set the specified channel ID.

・Message Content: Enter any message. You can also embed information obtained from ①.

このテンプレートを試してみる

How to request materials and apply for a demo

Here

Here are some Similar Templates!

When a response is submitted through Google Forms, the content of that response is automatically registered in any desired kintone app. It can be used for various purposes such as surveys and inquiry forms.

See details

Issue and send the quotation when the kintone status is updated.

When the status of kintone is updated, a quotation is automatically generated using the information from the related subtable of that record and a spreadsheet template, and sent via Gmail after approval. You can freely modify the content of the quotation, the recipient, the subject, etc. for your use.‍

See details

When a record is edited in kintone, notify LINEWORKS.

When a record is edited in kintone, it will automatically notify LINE WORKS. The content of the notification to LINE WORKS can be freely customized with the information of the edited record.‍

See details

Store the input form values in kintone.

When you enter a value into the input form, that value is automatically stored in kintone. The stored data can be viewed in the kintone app.

See details

Notify Talknote when a record is registered in kintone.

When a record is registered in kintone, a notification is sent to Talknote. This flow allows team members to stay informed of important information promptly without constantly monitoring kintone.

See details

When a record is registered in kintone, create a folder in Google Drive.

When a record is registered in kintone, a new folder is automatically created in Google Drive. At this time, the folder name is created based on the information registered in kintone. You can manage folders organized by project or customer automatically without accessing Google Drive.

See details

See all templates

About the Apps You Use

kintone

With Yoom, you can utilize kintone's API without any coding. For example, you can integrate kintone with other SaaS or create documents using information from kintone. Additionally, you can sync kintone information with Yoom's database and use kintone information for various purposes.

Related apps

kintone

Templates using

View all related templates

Google Sheets

At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.

Related apps