Automatically Get Image Links on Google Sheets Using Pabbly Connect

Learn how to automatically get image links on Google Sheets using Pabbly Connect and Pexels. Follow this detailed tutorial for seamless integration. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To automatically get image links on Google Sheets, you need to access Pabbly Connect. First, visit the Pabbly Connect website and sign up for an account if you don’t have one. If you already have an account, simply sign in to proceed with the integration process.

Once logged in, you will see the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button to start setting up your automation. This is where you will define the trigger and action applications needed for your workflow.

2. Setting Up Google Sheets as the Trigger Application

The first step in your automation is to set Google Sheets as the trigger application in Pabbly Connect. Select Google Sheets from the list of applications and choose the trigger event as ‘New or Updated Spreadsheet Row’. This event will initiate the workflow whenever a new row is added or an existing row is updated in your Google Sheets.

• Select Google Sheets as the trigger application.
• Choose the event ‘New or Updated Spreadsheet Row’.
• Copy the generated webhook URL for the next steps.

After copying the webhook URL, you need to set it in your Google Sheets. Go to your Google Sheets, click on Extensions, and navigate to Add-ons, then Get Add-ons. Search for the Pabbly Connect Webhooks add-on, install it, and ensure it’s activated for your sheet.

3. Configuring the Google Sheets Webhook

To finalize the connection between Pabbly Connect and Google Sheets, go back to Extensions, find Pabbly Connect Webhooks, and select ‘Initial Setup’. Paste the webhook URL you copied earlier into the designated field. Specify the trigger column where the data will be entered, which is column B in this case.

Ensure that the ‘Send on Event’ option is checked to allow data to be sent after each event. Once set up, send a test request to confirm that the connection is working correctly. You should see a success message indicating that the test data has been sent successfully.

4. Integrating Pexels for Image Retrieval

With the Google Sheets trigger set up, the next step is to integrate Pexels as the action application in Pabbly Connect. Choose Pexels from the application list and select the action event as ‘Search for Photos’. This action will allow you to retrieve image links based on the keywords specified in your Google Sheets.

• Select Pexels as the action application.
• Choose the action event ‘Search for Photos’.
• Connect your Pexels account by providing the API key.

After connecting, you will need to map the data fields from Google Sheets to the Pexels search parameters. Input the keywords you want to search for, set the orientation and size of the images, and send a test request to retrieve the image URLs. You will see multiple image links generated based on your keywords.

5. Updating Google Sheets with Retrieved Image Links

Finally, you will update your Google Sheets with the retrieved image links. Select Google Sheets again as the action application in Pabbly Connect and choose the action event ‘Update Range Values’. This step is crucial as it allows you to insert the image links into the appropriate cells in your Google Sheets.

Map the values you received from Pexels to the correct range in your Google Sheets. Specify the range where you want the image links to appear, such as C2 to E2, and format the values correctly within brackets and quotation marks. Once everything is set, send a test request to update the sheet.

Conclusion

By following this tutorial, you can successfully use Pabbly Connect to automate the process of getting image links on Google Sheets. This integration with Pexels allows you to efficiently retrieve high-quality images based on specific keywords, enhancing your productivity and workflow management. Start automating your tasks today using Pabbly Connect!