How to integrate TOKIUM with Google Sheets to automatically add invoices registered in TOKIUM to Google Sheets

Read the following screen display and click "OK".

When the following screen is displayed, check the "Title" and "Description".
If you want to make changes, do so on the following page.
First, go to the TOKIUM settings and click "When an invoice is registered".

Step 3: Set the TOKIUM trigger that initiates the flow and the subsequent Google Sheets operation settings

The following screen will be displayed, so check the settings.

• "Title" → Can be changed as desired
• "Account information linked with TOKIUM" → Check for any mistakes in the account
• "Trigger action" → When an invoice is registered
  

When the following screen is displayed, set the "Trigger activation interval".
Select from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
※ Note that the trigger activation interval varies depending on the plan.

Once the settings are complete, click "Test" → "Test Successful" → "Save".

Next, proceed with the Google Sheets settings by clicking "Add Record".
The following screen will be displayed, so check the settings.

• "Title" → Can be changed as desired
• "Account information linked with Google Sheets" → Check for any mistakes in the account
• "Execution action" → Add record
  

Move to the Google Sheets screen and set the TOKIUM invoice data you want to check in Google Sheets for testing purposes.
The following is an example, so set it as you like.

Return to the Yoom screen and set up "Database Integration".

• "Spreadsheet ID", "Spreadsheet Tab Name" → Select from the options or set as described
  

The item names set in Google Sheets earlier will be displayed, so use the TOKIUM output to set them as follows.
Click the arrow in the red frame to display the TOKIUM output.
Set the output that matches the item.

Once all settings are complete, it will be displayed as follows.
After completing the settings, click "Test" → "Test Successful" → "Save".

Step 4: Turn on the trigger button and verify the integration operation between TOKIUM and Google Sheets

Finally, click "Turn on Trigger" to complete the automation settings.
Check if the flow bot starts up correctly.

Here is the template used this time.

Other Automation Examples Using TOKIUM

1. This is a flow where a notification is automatically sent to Google Chat when an invoice is registered with TOKIUM.
‍Receiving notifications for invoice registrations ensures you won't miss anything.
You can check the invoice data on Google Chat, so there's no need to open TOKIUM specifically.

2. This is a flow where invoice files are automatically uploaded to Google Drive once they are registered in TOKIUM.
By saving invoice files to Google Drive, you can reduce the risk of document loss.
It eliminates the need to manually upload invoice files, thereby reducing the burden.

3. This is a flow to automatically add employee information to TOKIUM once it is registered in kintone.
It is recommended for those who register employee data on kintone.
It reduces the input effort by automatically synchronizing employee data.

Summary

By automating the invoice registration process that was previously done manually, you can prevent input errors and payment delays.
This eliminates the need for correction work and allows you to maintain up-to-date data at all times.
Additionally, sharing invoice information on Google Sheets may strengthen inter-departmental collaboration.
This automation is especially recommended for those conducting business across multiple locations or working remotely.

Let's free ourselves from the hassle of invoice registration by utilizing Yoom, which anyone can easily use.