.avif)
Click "Try this template".
Click "OK" and give the Flowbot a name to recognize.
The template will be copied to your "My Project".
Step 3: Set Up Google Sheets Trigger Action
Click on the trigger action with the Google Sheets icon.
The next screen is pre-configured. You can change the title if you want.
Then, set your trigger interval (how often you want Yoom to check Google Sheets for new updates).
It can be set to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. We recommend setting the trigger to the shortest activation interval available for your plan.
⚠️ Note: The trigger interval varies depending on your Yoom plan. Be sure to check your current plan’s limit.
Select the Spreadsheet ID and the Sheet ID from the displayed options.
Scroll down to enter the table range (start), table range (end), and the column that contains unique values.
📚 Reference: For more details on table range settings, check this guide.
For the Column with Unique Values, make sure to select a column with no duplicate values in this column. If there are duplicates, the process may not work correctly.
Once all the required fields are filled, click "Test" to check for errors.
If the test is successful, the retrieved value will be updated.
If there are no issues, click “Save”.
Step 4: Generate Images with OpenAI
Click on the action with the OpenAI icon.
The next screen is pre-configured. You can change the title if you want.
On the next page, configure the settings for generating the image.
The prompt serves as a guide for the image generation process, so be sure to incorporate the retrieved values from the previous step.
📚 Reference: For more details on retrieved values and how to set them up, see the guide here.
Adjust the number of images, image size, and the format as needed.
Once all settings are configured, click “Test” to verify the setup
For this example, we specified to generate 5 images. So you’ll see 5 image URLs appear in the retrieved values.
If the test succeeds, click “Save”.
Step 5: Update Record in Google Sheets
Click on the action with the Google Sheets icon.
Select Spreadsheet ID:
Choose the Spreadsheet ID from the displayed options.
Select Tab Name:
Choose the Tab Name where the data will be stored.
Define Table Range (Optional):
You can optionally specify the Table Range where data will be saved.
📚 Reference: For more details on table range settings, check this guide.
Then click “Next”.
① Set Conditions to Find Records to Update
Choose the conditions that must be met for the record to be updated. The tool will find the first matching record and update it. If multiple records match, only the first one in the list will be updated.
② Map the Data
Click on each item field and assign the corresponding data from the retrieved value to each field.
Step 6: Activate the Flowbot
Toggle the "Trigger On" button to activate your flow!
Check if the Flowbot you set up is working properly.
That’s it! 🎉 The Flowbot is now complete!
.avif)
.avif)
.avif)
