When a record is updated under specific conditions, it triggers the issuance and sending of an invoice based on the described content. After that, a send flag is set on the spreadsheet side.

Try this Template

No items found.

■Overview

‍This is a flow that automatically sends invoices when a specified column in a spreadsheet is updated.‍

‍

■Preparation and Precautions

‍・The spreadsheet itself cannot be used as a trigger.

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

Actual spreadsheet connected to data: https://docs.google.com/spreadsheets/d/1PipZ5rZJPe9Yf0YZjJ5TPQit7oHLpqIgZsDAE92wbhw/edit#gid=818459679

‍

‍■Creation Method (Database Data Connect)

① Create a new Yoom database and prepare one table with the following settings.

・Delete columns: Click each column name and delete all default columns.

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

・Execute Action: Select "Retrieve Record List".

・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:Q etc)

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

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

・Sync Frequency Setting: Select any time manually or automatically.

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

‍

‍■Creation Method (Flow Bot)

‍① Select the target table connected with the data connect in the database trigger and save it with the following settings.

・Trigger Action: When a record matching the condition is updated ・Target column: Set as equal to the target.

※ The image is that it activates when the word "target" is updated in the billing target column.

② Press the + mark, select the spreadsheet from the operation to issue a document, and perform the following settings for testing and saving.

・Spreadsheet ID: Select the spreadsheet ID to be used as a template for the invoice from the candidates.

・Folder ID to store in Google Drive: Select the folder ID to store after issuing the document from the candidates.

・File Name: Set any file name.

・String to Replace: Embed the value obtained in ① for the corresponding string.

※ Here is how to set up the operation to issue a document. https://intercom.help/yoom/ja/articles/8237765

‍③ Select the operation to send an email, choose any email tool, and save it with the following settings.

・To: Embed if the address was obtained in ①.

・Subject, Body: Enter each. You can also embed the value obtained in ①.

・Attachment: Select "Use Output" and choose the issued document as the value.

④ Press the + mark, select the spreadsheet from "Operate Database", and perform the following settings.

・Action: Update the record.

・Spreadsheet ID: Select the spreadsheet ID of the spreadsheet you want to update the record from the candidates.

・Spreadsheet Tab Name: Select the target sheet from the candidates. (In this case, select Example 2)

・Table Range: Select the range including the column name (header). (Example: A1:Q etc)

・Condition for the record you want to update: Select the column corresponding to the unique value obtained in ①, embed the unique value obtained in ① (in this case, the billing ID) as output, and search with the condition of being equal.

・Value to Update: Enter a string such as "Sent" in the send flag section.

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

How to request materials and apply for a demo

Here

Here are some Similar Templates!

Record the contents of the inquiry form in a Google Spreadsheet.

The content submitted through the inquiry form will be recorded in a spreadsheet, and a reply email will be sent automatically. The spreadsheet can include not only the inquiry details but also the reception date and time, as well as the sender's information.‍

See details

Read business card data using AI-OCR and store it in Google Sheets.

When you upload business card data to the form, the AI operation automatically extracts the necessary information from the business card, stores it in a Google Spreadsheet, and sets up a workflow to automatically send an email to the specified recipients.‍

See details

When a schedule is added to Google Sheets, register it in Google Calendar as well.

When an event is added to Google Sheets, this flow retrieves that information and registers the event in Google Calendar as well. By adding information to Google Calendar along with the registration in Google Sheets, it reduces manual operations and prevents missing information additions.

See details

When employee information is added to Google Sheets, register it in HRMOS.

This is a flow for registering employee information in HRMOS when it is added to Google Sheets. By using the registered employee information to register in HRMOS, it reduces manual time. Additionally, using the quoted content prevents human error.‍

See details

When there is a response to the form, add the information to a Google Spreadsheet and send a notification on LINE.

When there is a response to the inquiry form, the information will be added to a Google Spreadsheet and a notification will be sent to the LINE chat room.‍

See details

Add a record to kintone when a row is added in Google Sheets.

This is a flow where a record is added to kintone when a row is added in Google Sheets. Once information is added, the registration to kintone can also be automatically completed based on the added content, eliminating the need for manual input and ensuring the accuracy of the content.‍

See details

See all templates