📝 Overview

Yoom integrates with Google Sheets to perform various operations.

In this guide, we'll show you how to insert images into specific cells in Google Sheets by manipulating a database.

We’ll walk you through the following example:

Prepare a Google Sheet to store the data.
Set up a form trigger to collect company name, contact person, and attached images.
Upload the images to a specified Google Drive folder.
Insert the collected information and uploaded images into the Google Sheet from step 1.

🛠️ How to Configure

1. Prepare a Google Sheets to Store Data

Start by setting up a Google Sheet with column names as shown below. This sheet will store information added via the form or Google Drive. When the flowbot runs, the collected information will be inserted as rows beneath the column names.

2. Set Up a Form Trigger to Collect Information

Next, create a new Flowbot and configure the form trigger:

Select “Form Trigger” from the list.
Enter the necessary fields, including a file attachment field for uploading images.
After completing the settings, input sample values and image data on the next page, then save.

For detailed information on forms, please refer to this help page.

3. Upload the Images to Google Drive

Now, set up the Google Drive operation:

Click the “+” icon and select Google Drive from the app integration options.
Configure the following settings:
- Action: Upload file
- Destination folder ID: Choose any folder from the suggestions.
- File name: Enter a name for the file. You can reference the form's value.
- File attachment method: Select “Use output” and choose the image data uploaded via the form.

☝️ Important:

For the images to display in Google Sheets, make sure the Google Drive folder permissions are set to “Anyone with the link can view.”

4. Insert the Information and Image into Google Sheets

Finally, set up the Google Sheets operation:

Click the “+” icon, then select Google Sheets from the database operations.
Configure the settings as follows:
- Action: Add a record
- Spreadsheet ID: Choose the Google Sheet from step 1.
- Spreadsheet tab name: Select the sheet from the Google Sheet.
- Table range: Choose the range where you want the data inserted.

For more details on selecting the record range, please refer to this help page.

Values of the Added Record:

For fields like company name and contact person, select the form output and embed it.

For the attached images, use the following formula:

=IMAGE("https://drive.google.com/uc?export=view&id={{File ID}}")

For the URL, use:

https://drive.google.com/file/d/{{File ID}}

☝️ Note:

The file ID from the file upload operation should be embedded in place of {{fileID}}. If the file type is not an image or PDF, the link will be different. Please refer to this help page for more details.

When the flowbot runs, the form responses, images, and Google Drive folder URL will be added to Google Sheets, as shown below.

☝️ Note:

The rows are enlarged for clarity, but they won’t automatically resize.

To display images inserted into Google Sheets, the Google Drive folder must have permissions set to "Anyone with the link can view."

That’s it! 🎉

Now you know how to insert images into Google Sheets using Yoom.

📚 Related Guides

Basic & Optional Form Settings - View Guide Here
Generating Links for Google Services - View Guide Here
Scope Settings for App Integration & Database Operation in Google Sheets - View Guide Here

Related Keywords

Google, Google Drive, Drive, image, insert image, file upload, Google Spreadsheet, Google Sheets, Yoom, Automation