Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start automating video generation, you need to access Pabbly Connect. Open a new tab and search for pabbly.com/connect to reach the landing page. If it’s your first time, sign up for free to receive 100 free tasks every month, allowing you to test this automation setup.

Once you are logged in, you can create the necessary workflows. This initial step is crucial as it sets the foundation for connecting Google Sheets with the Gemini API through Pabbly Connect.

2. Setting Up Google Sheets with Pabbly Connect

The next step involves configuring Google Sheets to work with Pabbly Connect. You need to set up a trigger that will activate whenever a new row is added or updated in your spreadsheet. Choose the trigger as “Google Sheets New or Updated Spreadsheet Row”.

  • Log into your Google Sheets and navigate to Extensions.
  • Select Add-ons and then Get Add-ons.
  • Search for Pabbly Connect Webhooks and install it.

After installation, refresh your spreadsheet and set up the webhook URL provided by Pabbly Connect. This URL will capture the data from the last column where you input your video prompt.

3. Capturing Data in Pabbly Connect

Once the Google Sheets setup is complete, you need to ensure that the data is captured correctly in Pabbly Connect. With the webhook URL configured, turn on the “Send on Event” option in the Pabbly Connect Webhooks settings. This will allow data to be sent automatically when a new prompt is entered.

Now, enter a video prompt in your Google Sheets. For example, you can input a prompt like “Create a mouth-watering cinematic advertisement of a gourmet burger”. As soon as you do this, Pabbly Connect will capture the response, indicating that your Google Sheets is successfully connected.

4. Generating Video with Gemini API through Pabbly Connect

The next step is to connect to the Gemini API using Pabbly Connect. Click on the “Connect” option and add a new connection. You’ll need to provide the API key from your Gemini account. Navigate to the Gemini playground section to generate your API key.

After entering the API key in Pabbly Connect, map the video prompt data from the previous step. This mapping ensures that whenever a new prompt is added, it will dynamically update in the video generation request.

  • Create a high-quality video based on the prompt.
  • Map the prompt and style data correctly.
  • Click on “Save and Send Test Request” to generate the video.

After a few seconds, you will receive a URI link to your generated video. This link is essential for the next step where you will add the video back to Google Sheets.

In the final step, you will add the generated video link back into your Google Sheets using Pabbly Connect. Connect back to Google Sheets and select the account you used to create the spreadsheet. Choose the specific sheet where you want to insert the video link.

Map the data to the appropriate columns, particularly Column C for the video link. Ensure that you also map the row index to keep track of the correct entry. Finally, click on “Send Test Request”. This will update your Google Sheets with the video link, allowing your team members to access it easily.

Conclusion

By using Pabbly Connect, you can seamlessly automate the process of generating videos from prompts entered in Google Sheets. This integration not only saves time but also ensures that your team can access video links without sharing credentials. With just a few steps, you can enhance your video creation workflow efficiently.