Creating Dynamic Images with Pabbly Connect and Canvas Templates

Learn how to create dynamic images using Pabbly Connect, Google Sheets, and Switchboard Canvas templates. Follow this detailed tutorial for seamless integration. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To begin creating dynamic images using Pabbly Connect, first, access the Pabbly Connect dashboard. If you don’t have an account, you can easily sign up for free. Once logged in, you will see the option to create a new workflow.

Click on ‘Create Workflow’ and name it appropriately, such as ‘Google Sheets to Switchboard Canvas.’ This workflow will serve as the foundation for integrating Google Sheets with Switchboard Canvas through Pabbly Connect.

2. Setting Up Google Sheets Trigger in Pabbly Connect

The next step involves setting up a trigger in Pabbly Connect. Search for Google Sheets in the trigger app window and select it. Choose the trigger event as ‘New or Updated Spreadsheet Row.’ This will initiate the workflow whenever a new row is added or an existing one is updated.

• Select Google Sheets as the trigger app.
• Choose the trigger event: New or Updated Spreadsheet Row.
• Copy the webhook URL provided by Pabbly Connect.

After copying the webhook URL, you need to set it up in your Google Sheets. Go to Extensions, select Add-ons, and search for ‘Pabbly Connect Webhooks.’ Install this add-on and refresh your Google Sheet. Once refreshed, go back to Extensions, hover over the Pabbly Connect Webhooks option, and click on ‘Initial Setup’ to paste the webhook URL.

3. Configuring Switchboard Canvas Action in Pabbly Connect

After setting up the trigger, the next step is to configure the action that will take place in Switchboard Canvas. In the action window of Pabbly Connect, search for Switchboard Canvas and select it. Choose the action event as ‘Create Image.’ This action will create the dynamic image based on the data received from Google Sheets.

To connect your Switchboard Canvas account, you will need the API key from your Switchboard Canvas account. Go to the template section in Switchboard Canvas, find the API key option, and copy it. Paste this key into Pabbly Connect to establish the connection.

• Select ‘Create Image’ as the action event.
• Map the fields such as image URL and title from Google Sheets.
• Test the action to ensure the image is created successfully.

After mapping the necessary fields, click on ‘Save and Test’ to verify that the image is created as intended. This step confirms that the integration between Google Sheets and Switchboard Canvas through Pabbly Connect is functioning correctly.

4. Updating Google Sheets with the Image URL

The final step in this automation process involves updating the Google Sheet with the URL of the newly created image. In Pabbly Connect, add another action step and select Google Sheets again. This time, choose the action event as ‘Update Cell Value.’ This will ensure that the URL of the generated image is sent back to the appropriate cell in Google Sheets.

In the setup for this action, select the spreadsheet and the specific sheet where you want to update the image URL. For the cell range, specify the cell where the image link should be updated. Instead of hardcoding the cell reference, map the row index from the trigger response to dynamically update the correct row.

Choose the correct spreadsheet and sheet. Map the row index to update the correct cell dynamically. Test the action to confirm the image URL is updated successfully.

Once you have mapped the necessary fields, click on ‘Save and Test’ to validate that the image URL is correctly updated in your Google Sheet. This completes the automation, allowing you to generate dynamic images automatically with Pabbly Connect.

Conclusion

In this tutorial, we explored how to create dynamic images using Pabbly Connect, Google Sheets, and Switchboard Canvas. By following the steps outlined, you can automate the process of generating images and updating your Google Sheets seamlessly. This integration not only saves time but also enhances your content creation workflow.