Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, you need to create an account. Simply visit pabbly.com/connect and sign up for free. Once registered, you will receive 100 free tasks every month, which you can use to test your integrations.

After logging in, navigate to your dashboard. From here, you can create a new workflow. This initial setup is crucial for automating your Google Sheets and Creator integration. With Pabbly Connect, you can streamline your tasks without needing coding skills.

2. Creating a Workflow in Pabbly Connect

To create a new workflow in Pabbly Connect, click on the “Create Workflow” option. Choose the “Create Using Quick Builder” feature. This allows you to generate an automation workflow quickly by entering a simple prompt.

Your prompt should describe the automation you want, such as “Every new text in Google Sheets should generate a video using Creator and update the link back in Google Sheets.” This setup will ensure that data flows seamlessly through Pabbly Connect.

  • Click on the “Create Workflow” button.
  • Select “Create Using Quick Builder”.
  • Enter your automation prompt.

After entering your prompt, approve it to create the workflow. This step is essential for ensuring that Pabbly Connect can handle your automation efficiently.

3. Setting Up Google Sheets with Pabbly Connect

Next, you need to set up Google Sheets to work with Pabbly Connect. In your Google Sheets, go to Extensions, then Add-ons, and search for “Pabbly Connect Webhooks” to install it. This integration will allow your Google Sheets to send data to Pabbly Connect.

Once installed, refresh your Google Sheets. Go back to Extensions, find “Pabbly Connect Webhooks,” and select the Initial Setup option. Here, you will paste the webhook URL provided by Pabbly Connect and define your trigger column.

  • Install the Pabbly Connect Webhooks add-on.
  • Paste the webhook URL in the Initial Setup.
  • Define your trigger column (e.g., Column A).

After completing the setup, you will receive a confirmation that the setup was successful, indicating that your Google Sheets is now integrated with Pabbly Connect.

4. Generating Video with Creator Using Pabbly Connect

With Google Sheets set up, the next step is to generate a video using Creator. In Pabbly Connect, you will connect to Creator by providing the API token. This token allows Pabbly Connect to authenticate and interact with Creator seamlessly.

To find your API token, open the template you created in Creator, navigate to API Integrations, and copy the token. Paste this token into Pabbly Connect to establish the connection. This step is vital for ensuring that the video generation is automated based on the data from Google Sheets.

  • Copy the API token from Creator.
  • Paste the token into Pabbly Connect.
  • Select the template for video generation.

Once the connection is established, you can map the data from Google Sheets to the Creator template. This allows Pabbly Connect to dynamically generate videos based on the text input in your spreadsheet.

After the video is generated, the final step is to update Google Sheets with the generated video link. In Pabbly Connect, you will create a new connection to Google Sheets to send the video link back.

Choose the Google Sheets account and select the spreadsheet where you want to update the video link. Specify the column (e.g., Column B) and the row index where the link should be placed. This step ensures that your Google Sheets is updated automatically with the new video link each time a new entry is made.

  • Select the Google Sheets account.
  • Specify the spreadsheet and column for the video link.
  • Map the video link to the specified column.

After completing these steps, you will see the video link updated in your Google Sheets automatically. This integration showcases the power of Pabbly Connect in automating workflows effectively.

Conclusion

In this tutorial, we explored how to integrate Google Sheets with Creator using Pabbly Connect. By following these steps, you can automate video creation and update your Google Sheets seamlessly. This integration not only saves time but also enhances productivity.