Google DriveとGoogle スプレッドシートの連携イメージ
How to Integrate Applications

2025-04-17

How to register business card images added to Google Drive into Google Sheets using AI-OCR

a.ohta

Exchanging business cards is an important activity for business professionals. However, managing and processing business cards can be a hassle when the number grows. Even if you’ve successfully exchanged business cards, manually entering each one into your company’s system later can be extremely time-consuming.

To help solve this issue, this article introduces a way to automate the registration of business card data using Google Drive and Google Sheets!

Recommended for

  • Those who save business card images in Google Drive and want to manage the information in Google Sheets
  • Those looking to streamline their workflow using Google Drive and Google Sheets
  • Those who want to avoid missing entries when transferring business card data from Google Drive to Google Sheets

For those who want to try it right away

This article introduces an integration method using the no-code tool Yoom.
No complicated setup or operations are required, so even non-engineers can implement it easily.
You can get started right away using the template below—give it a try!

[About Yoom]

How to Create a Workflow Integrating Google Drive and Google Sheets

Now, let's create a "Flow Bot" that reads business card information and adds it to Google Sheets when a business card is uploaded to Google Drive.

Instead of creating a Flow Bot from scratch, you can save time by using a template that already has the flow set up as shown in the image above.
First, click "View Details" on the banner of the template below, and proceed with Yoom registration from the "Try this template" button at the bottom of the screen!
If you have already completed the registration, the login screen will be displayed, so please log in!

My App Settings

Once registration is complete, you will be redirected to a page called "My Projects".
Next, let's integrate Google Drive and Google Sheets with Yoom.
This is called "My App Integration"!

Select "My Apps" from the menu on the left side of the screen!

Let's start with integrating Google Drive with My Apps!

From the new connection button at the top right, enter "Google Drive" in the search box, and click when the Google Drive icon appears!

On the page titled Select Account, press the Google account of the Gmail address you want to integrate with Yoom.
Next, you will be redirected to a page titled Login to Yoom, so click Next.
Finally, if a page titled Yoom is requesting additional access to your Google Account appears, press Continue to proceed!

If the above screen appears, press the red frame below.
Next, you will be redirected to the authentication screen, so make sure to allow all permissions.

Next, we will integrate Google Sheets, but since it is also a Google service like Google Drive, the steps for My App Integration are the same.
Search for "Google Sheets" in the search box and register!

Once both Google Drive and Google Sheets are integrated with Yoom, the next step is to configure the contents of the Flowbot!
The setup process for this Flowbot consists of 4 steps!

Google Drive Trigger Settings

First, since it will be necessary when setting up the Flowbot, create a folder in Google Drive to store business cards and upload the business cards.

Once you have uploaded the business cards to the folder, open the Yoom screen and click "Copy: When a business card is uploaded to Google Drive, read the business card information and add it to Google Sheets" from My Projects on the left side of the screen!
Press Edit at the top right.

Press the Google Drive icon for "When a new file or folder is created in a specific folder".
Since the necessary fields are already filled in using the template, check if the Google Drive account information is correct and click Next!

Enter the folder ID.
When you click inside the box, a list of folders will be displayed, so select the folder where you uploaded the business cards.

Once selected, there is a "Test" button just below, so click it. If it displays "Test Successful" in blue, you're good to go, so save it!

Google Drive Settings

Press the Google Drive icon for "Download File".
Again, since the necessary fields are already filled in using the template, check if the Google Drive account information is correct and click Next.

Enter the file ID, but since you are using a template, it is already set up.

Therefore, as before, press the test button, and if it displays "Test Successful" in blue, you're good to go!
Don't forget to save it.

Read Images/PDFs

Press the book icon for "Read Text from Image/PDF".
Again, since the necessary fields are already filled in, check if the account information is correct and click Next!

Set what content to extract from the business card.
However, since you are using a template, no input is required...!
The items to be recognized are already set as shown in the red frame.

If there are other strings you want to recognize, you can input them in the box, and they will be reflected, so set them as needed.
As before, press the test button. If it displays "Test Successful" in blue, save it.
*The AI operations for OCR or transcribing audio to text are only available in the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operations set in the Flowbot will result in an error, so please be careful. Paid plans like the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use restricted apps and AI features (operations).

Google Sheets Settings

Next is the Google Sheets setting, but a sheet to add the read business card information is required.
Therefore, create it at this stage.

I created it as shown in the image this time!
Once the Google Sheet is created, proceed to the next step.

Press the Google Sheets icon for "Add Record".
Check if the account information to be linked is correct and scroll down.

Select the spreadsheet ID and tab name. First, enter the spreadsheet ID.

When you click inside the box, a list will be displayed as shown in the image, so select the Google Sheet where the business card information will be accumulated.
Set the tab name in the same way, and you're good to go!

For other fields, they depend on the prepared Google Sheet, so input according to the content of the Google Sheet.
Once input is complete, press Next.

Next is the final setting! Set the values for the records to be added!

The box names displayed on this page depend on the Google Sheet you linked earlier.
Therefore, the display may differ from the image, but the setup method is the same.

Click inside the box and select "Read Text from Image/PDF", and the information from the business card you uploaded earlier will be displayed in a list as shown in the image.
Just choose the content that matches the box name, and you're good to go!

In the image, the company name box is selected, so the business card information also selects the company name.

Once you fill in the boxes as shown in the image, press the test button just below, and if it displays "Test Successful" in blue, press Save.
This completes the integration of Google Drive and Google Sheets!

Yoom has many other Flowbot templates available, so be sure to check them out.

Other Automation Examples Using Google Drive and Google Sheets

In addition to the integrations introduced today, various automations can be achieved by utilizing the APIs of Google Drive and Google Sheets.

If you find something interesting, please give it a try!

Automation Examples Integrating Google Drive and Google Sheets

It is possible to automatically add information to Google Sheets after saving a file to Google Drive, or to automatically add information to Google Sheets by reading survey images uploaded to Google Drive. Additionally, it is possible to read invoices submitted through a form using AI, append the data to Google Sheets, and then automatically save it to Google Drive.

Automation Example Using Google Drive

Notify Chat Tools When Files or Folders Are Created in Google Drive

Automatically send notifications to tools like Slack or Discord when files or folders are created in Google Drive.

Upload Email Attachments to Google Drive

Automatically upload attachments received in Gmail or Outlook to Google Drive.

Create a folder in Google Drive when an account is registered in another app

Automatically create a folder in Google Drive when an account is registered in Salesforce, HubSpot, or other applications.

Automation Example Using Google Sheets

Notify Chat Tools When a Row is Added in Google Sheets

Automatically notify tools like Slack or Discord when a row is added in Google Sheets.

Add the content registered in the database to Google Sheets

Automatically add the content registered in Airtable, Salesforce, etc., to Google Sheets.

Issue documents based on information from Google Sheets

Automatically create documents such as DocuSign and Google Docs based on the content registered in Google Sheets.

Benefits of Integrating Google Drive and Google Sheets

1. Automatically Read Image Data from Google Drive and Add to Google Sheets!

You can automatically read the text on business cards uploaded to Google Drive and add details such as company names, personal names, and addresses to Google Sheets!
With just one action of uploading a business card to Google Drive, the entire process can be automated, eliminating the need to manually enter numerous business cards and saving time.

2. Editing is Possible by Listing in Google Sheets!

Once the business card information is added to Google Sheets, collaborative editing and management become possible, allowing you to add detailed research about company information!
By supplementing the necessary data to the business card information added to Google Sheets, you can reuse the data for future sales activities and marketing.

Summary

By storing business cards in Google Drive and automatically reading and adding their content to Google Sheets, you can manage this information collaboratively at any time.
It's a great advantage to be able to easily share and utilize business cards that were previously managed individually!
It also makes it easier to list client companies, so please take this opportunity to try it out!

The person who wrote this article
a.ohta
After working as a general store manager, I started working from home as an SEO writer. Later, an outsourcing agreement was signed with a marketing startup for about 5 years. Surrounded by students at the University of Tokyo, I held a computer and spent my days studying various business terms and how to use SaaS tools. When I was a general store manager, time was taken over and over again by office work such as sales and inventory management, human resource management, and ordering, etc., and I was unable to serve customers and often missed sales times. Even when outsourcing, there are many detailed tasks such as input, etc., and “can't such monotonous tasks be automated?” I thought so, and I really sympathize with Yoom's vision!
Tags
Google Drive
Google Sheets
Automation
Integration
Automatic
App integration
No items found.
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