How to generate an image with OpenAI from the content added to Google Sheets and update the obtained URL in Google Sheets

[About Yoom]

How to Create a Workflow Integrating Google Sheets and OpenAI

Let's actually integrate Google Sheets with OpenAI.
This workflow involves "Generating an image with OpenAI from content added to Google Sheets and updating the obtained URL back into Google Sheets."

1. Set up a trigger in Google Sheets
2. Configure settings for image generation in OpenAI
3. Set up configurations to update Google Sheets

The setup is completed in 3 steps, so first, let's copy the flow by clicking "Try this template" on the banner below!

Preparation

Before getting into the actual setup, connect Yoom with Google Sheets and OpenAI.
After logging into Yoom, click on "+ New Connection" from the "My Apps" menu on the left.

‍

‍

Search for each app name and enter the necessary information for login.
Once the app integration is complete, it will appear in the My Apps list, so make sure to check it.

‍

‍

If Google Sheets is also displayed in the same way, the preparation is complete.
Let's proceed to the detailed settings right away.

* To execute ChatGPT (OpenAI) actions, you need to subscribe to OpenAI's paid API plan.
(Payment must be possible when the API is used)
‍https://openai.com/ja-JP/api/pricing/
‍ChatGPT's API usage is provided by OpenAI for a fee, and it is a pay-as-you-go system based on tokens during API communication.
Therefore, if you are not in a situation where you can make a payment when using the API, an error will occur, so please be careful.

App Trigger Settings

‍

‍

First, click on the initial setting "When a row is added".
On the first page, check the account information that has already been linked in advance.

‍

‍

No changes are needed for other items, so click "Next" as is.

‍

‍

On the next page, set the range for Google Sheets.
<span class="mark-yellow">Make sure to set a column with unique values as "Column with Unique Values".</span>If values are duplicated within the column, it may not work correctly.

Once all items are entered, click "Test" to check for errors.
If the test is successful, the specified Google Sheets items will be reflected as output.

‍

‍

The above output (Google Sheets items) will be used as prompts for image generation, so <span class="mark-yellow">make sure to create items that cover the necessary information.</span>

If there are no issues up to this point, click "Save" to complete the trigger settings.

OpenAI Settings

‍

‍

Next, click on "Generate Image from Text".
On the first page, just like with Google Sheets, only confirm the account information and select "Next".

‍

‍

On the next page, set the details for generating the image.
The prompt is an instruction manual for image generation, so try to create it while effectively reflecting the output used in the previous step.

Change the number of images, image size, and format to the necessary settings.
Once you have set everything, click "Test" to check.

In this setup, 5 images are instructed to be generated, so 5 image URLs will appear in the output.

‍

‍

If there are no errors, click "Save" to complete the OpenAI settings.

Google Sheets Update Settings

‍

‍

Finally, click on "Update Record".
On the first page, enter the Google Sheets information to update the record below the account information.

‍

‍

Click "Next" to check for errors.
On the next page, make detailed settings for the update.

‍

This is for "Updating rows that match condition ① to value ②", so use the output to set it up.

Once all necessary fields are filled, click "Test" to check for errors.
If there are any errors, correct them according to the content.

Once all errors are resolved, click "Save" to complete all settings!
Finally, turn on the trigger to start the flow.

‍

‍

Other Automation Examples Using Google Sheets and OpenAI

In addition to the flow introduced this time, you can achieve various business automations by using Google Sheets and OpenAI's API.
All of them can be used with simple settings, so if you find something that interests you, please give it a try!

Other Automation Examples with Google Sheets and OpenAI

Automatically transcribe audio files uploaded to Dropbox and summarize them using OpenAI's AI summarization feature.
After that, it is a flow bot that automatically adds the results to Google Sheets.
This may eliminate the need for manual data organization and allow for smooth information management on Google Sheets.

Automation Example Using Google Sheets

Create a Contract When a Row is Added in Google Sheets

By simply adding a row in Google Sheets, an order form is automatically generated, allowing work to proceed quickly.

Update Contact Information When a Row is Updated in Google Sheets

This is a flow bot that updates contact information when a row is updated in Google Sheets.
Automation helps prevent human errors such as input mistakes and missed updates.

When a schedule is registered, add a record to Google Sheets

When a schedule is registered, the registration information can be automatically added to Google Sheets, which should streamline manual tasks.

‍

Automation Example Using OpenAI

Transcribe and analyze text with OpenAI and send notifications when specific actions are performed

This is a flow bot that notifies chat tools of analysis results or transcription results when an audio file is added or a form is answered.
Additionally, it can extract questions from the message body and receive responses after interacting with OpenAI.

Benefits of Integrating Google Sheets with OpenAI

Benefit 1: Improved Time Efficiency

By integrating Google Sheets with OpenAI, you can automatically generate image ads for campaigns by simply entering the necessary information into a specified sheet.

This eliminates the need for marketers to manually request designs, allowing for quicker campaign launches. For instance, even if a sudden promotion is needed, AI can quickly generate images, making efficient use of limited time. Additionally, for those managing images, data is centrally managed in Google Sheets, reducing the risk of image loss or duplication and facilitating smoother management tasks.

Benefit 2: Easier Image Sharing Among Teams

Successful ad campaigns require effective communication among all team members. By integrating Google Sheets with OpenAI, generated images can be directly added to Google Sheets and shared with everyone immediately.

For example, when a new image is generated, it can be shared in Google Sheets on the spot, allowing team members to provide comments and feedback right away. This makes it easier to align ideas and smoothly propose improvements. As a result, projects can progress quickly, saving both time and effort.

Conclusion

Yoom is user-friendly even for those without programming knowledge, making it easy to set up the integration between Google Sheets and OpenAI. This integration not only automates the generation of image ads for campaigns but also automates data management, enhancing work efficiency. By eliminating the hassle of image generation, marketers can focus more on strategic tasks. Why not register for Yoom for free now and make your work even more efficient?