Creating Thumbnails from Google Sheets in Bulk with Pabbly Connect

Learn how to create thumbnails in bulk from Google Sheets using Pabbly Connect. This tutorial covers step-by-step integration with Google Sheets and Switchboard Canvas. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Thumbnail Creation

To create thumbnails from Google Sheets in bulk, the first step is to set up Pabbly Connect. This automation tool allows you to integrate different applications seamlessly. Visit the Pabbly Connect landing page to create your free account and sign in to access the dashboard.

Once logged in, click on the ‘Create Workflow’ button. Name your workflow something descriptive, like ‘Bulk Thumbnails from Google Sheets’. After naming your workflow, click on the ‘Create’ button to proceed with setting up the automation.

2. Connecting Google Sheets as the Trigger Application

In this step, you’ll connect Google Sheets as the trigger application within Pabbly Connect. This means that whenever new data is added to your Google Sheets, it will initiate the workflow. Select Google Sheets from the list of applications.

• Choose the ‘Get Rows’ action event.
• Connect your Google account that holds the spreadsheet.
• Select the spreadsheet name, which in this case is ‘Video Thumbnails’.

Make sure to specify the data range correctly (e.g., A2:B4) to fetch the relevant rows. This setup allows the automation to pull the necessary data for thumbnail creation.

3. Scheduling the Workflow to Run Daily

To ensure that your thumbnails are created automatically, you need to schedule the workflow using Pabbly Connect. In the workflow settings, select the ‘Scheduler’ feature to run the automation every day at a specific time.

Set the time according to your time zone (e.g., 6 PM). This means that every day at this time, Pabbly Connect will check your Google Sheets for any new data and trigger the thumbnail creation process.

4. Utilizing the Iterator Feature for Bulk Processing

After fetching data from Google Sheets, the next step is to use the Iterator feature in Pabbly Connect. This allows the workflow to process each row of data one by one, creating thumbnails for each entry.

• Add the Iterator step after the Google Sheets action.
• Select the array of data captured from your previous step.
• Map the fields for title and photo from the iterator output.

This setup ensures that each row is processed individually, allowing for bulk thumbnail creation using the data from your Google Sheets.

5. Creating Thumbnails with Switchboard Canvas

Now that your data is set up and the iterator is in place, you can proceed to create thumbnails using the Switchboard Canvas application through Pabbly Connect. Select Switchboard Canvas as the action application and choose the ‘Create Images’ action event.

You will need to connect your Switchboard Canvas account by providing the API key. After connecting, select the template you created for thumbnails and map the necessary fields (like image and text) to the corresponding data from the Google Sheets iterator.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the creation of thumbnails from Google Sheets in bulk. By following the steps outlined, you can set up a seamless workflow that runs daily, ensuring your thumbnails are always up to date.