.avif)
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 be displayed in the My Apps list, so make sure to check it.
If Google Sheets is also displayed, the preparation is complete.
Let's proceed to the detailed settings.
*To execute ChatGPT (OpenAI) actions, you need to subscribe to OpenAI's paid API plan.
(Ensure payment can be made 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 charged based on tokens during API communication.
Therefore, if you cannot make a payment when using the API, an error will occur, so please be careful.
App Trigger Settings
First, click on the initial setting "Once the row is added".
On the first page, check the account information that has been pre-linked.
No changes are needed for other items, so click "to the next"as is.
On the next page, set the range for Google Sheets.
<span class="mark-yellow">Especially for the "column with unique values", make sure to set a column with unique values.</span>If there are duplicate values 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, the trigger settings are complete by clicking "Save".
OpenAI Settings
Next, click on "Generate Images from Text".
On the first page, just confirm the account information like with Google Sheets and select "to the 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 by effectively reflecting the output used in the previous step.
Change the number of images, image size, and format as needed.
Once the settings are complete, click "Test" to verify.
In this setup, 5 images are instructed to be generated, so 5 image URLs will appear in the output.
If no errors occur, the OpenAI settings are complete by clicking "Save".
Google Sheets Update Settings
Finally, click on "Update a record".
On the first page, enter the Google Sheets information to update the record below the account information.
Click "Next" to check for any errors.
On the next page, make detailed settings for the update.
This is for "updating the row that matches 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 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.
.avif)
.png)
.png)
