Connect HeyGen and Google Sheets integrations
Automate your video production tracking by connecting HeyGen and Google Sheets through Make—instantly capture video generation data, completion status, and production details directly into your spreadsheets without manual work. Set HeyGen events as triggers and let Make's visual workflow builder log every video milestone, transforming your manual data entry into automation.
Triggers when a new avatar video is done either as a success or as a failure. Only triggers for videos generated via the API.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specific cell.
Clears values from a specific row.
Clears a specified range of values from a spreadsheet.
Copies a sheet to another spreadsheet.
Creates a new spreadsheet.
Creates a new spreadsheet from a template sheet.
Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Performs an arbitrary authorized API call.
Returns processed data as a result of the MAKE_FUNCTION or INTEGROMAT function. Sheets Add-On required.
Renames a specific sheet.
Updates a specific cell.
Updates a row.
Returns a sheet’s content defined by range values.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.
Trusted by thousands of fast-scaling organizations around the globe
Automate your work. Build something new.
Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.
Build your HeyGen and Google Sheets integrations.
Connect Google Sheets and HeyGen through Make's integration platform by using Google Sheets as a trigger and HeyGen as an action. Set Google Sheets events as triggers to automatically initiate workflows, then configure HeyGen as the action to update spreadsheets with video generation data. When Google Sheets completes a video or reaches a specific status, the trigger activates and sends information to HeyGen, where you can automatically log video details, track production status, or record completion data in your spreadsheets. Make's visual workflow builder lets you map data fields from Google Sheets trigger events to corresponding columns in HeyGen, creating automated workflows that capture video generation information directly into your spreadsheets without manual data entry.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specified range of values from a spreadsheet.
Clears a specific cell.
Clears values from a specific row.
Copies a sheet to another spreadsheet.
Popular HeyGen and Google Sheets workflows.
Automate video creation by connecting HeyGen's AI video generation with Google Sheets. Transform spreadsheet data into professional personalized videos at scale, eliminating manual work and improving your entire content production workflow.
Manage bulk video projects from a centralized dashboard, automatically track generation status, and produce hundreds of customized video variations for marketing campaigns or training programs—all through a spreadsheet interface.
How to setup HeyGen and Google Sheets in 5 easy steps
Add your app module in Make
Log into your Make account and open the scenario where you want to build your automation. Click to add a module and choose either Google Sheets or HeyGen as your first app. Once you've selected your app, you'll see a button to create a connection, which is how you'll link Make to your chosen application so they can communicate with each other.
Click the connection button and name it
After adding your module, click the 'Create a connection' button to start the setup process. A window will open with a field called 'Connection name' where you can give your connection a descriptive name like 'My Google Sheets Connection' or 'HeyGen Work Account.' While naming is optional, it helps you identify which connection you're using, especially if you work with multiple accounts for the same app.
Get your HeyGen API credentials
For HeyGen, you'll need an API key to connect. Log into your HeyGen account, click on your profile name in the upper left corner, and select the Settings icon. Navigate to 'Subscriptions & API' in the sidebar, click 'HeyGen API,' and copy the API Token that appears. This token acts like a secure password that allows Make to access your HeyGen account safely.
Enter credentials or sign in with Google
If you're connecting HeyGen, paste the API token you copied into the 'API Key' field in Make's connection window, making sure there are no extra spaces. For Google Sheets, the process is more straightforward—just click the 'Sign in with Google' button and log in with your Google account credentials. Google will then ask you to grant Make permission to access your spreadsheets, which you'll need to accept for the connection to work.
Save and start using your connection
Click the 'Save' button to finalize your connection. Make will verify that everything works correctly and show you a confirmation message when successful. Once your connection is established, you can immediately start using the app in your automations, and you can reuse this same connection across multiple scenarios without needing to reconnect each time.
Automate video production with HeyGen and Google Sheets integration
Connect HeyGen and Google Sheets to automate bulk video creation, centralize content management, and improve your workflow. Generate hundreds of personalized AI videos from spreadsheet data.
Generate multiple personalized HeyGen AI videos automatically from a single Google Sheets spreadsheet, eliminating manual one-by-one video creation.
Track all your video projects, scripts, and generated video links in one organized Google Sheets location for team collaboration and reference.
Automatically capture and update video links in your spreadsheet once HeyGen completes generation, removing the need to manually check video status.
Transform spreadsheet data directly into professional AI videos without switching between platforms or copying information manually.
FAQ
By connecting HeyGen with Google Sheets on Make, you can automatically generate personalized AI videos based on data stored in your spreadsheets. For example, you can create bulk video content using customer names, product details, or campaign information directly from your Google Sheets rows. This eliminates manual data entry into HeyGen and allows you to produce hundreds of customized videos efficiently, perfect for personalized marketing campaigns, sales outreach, or customer onboarding at scale.
Make enables you to create powerful automated workflows such as: triggering video generation in HeyGen whenever a new row is added to Google Sheets, logging completed video details back to your spreadsheet for tracking, updating video status and URLs automatically, or creating videos based on form submissions that populate your sheets. You can also set up conditional logic to generate different video types based on specific data values, making your video production process completely hands-free and data-driven.
No coding skills are required! Make provides a visual, drag-and-drop interface that makes it easier to connect HeyGen and Google Sheets. You select triggers (like 'new row in Google Sheets') and actions (like 'create video in HeyGen'), then map the data fields between the two apps. Make handles all the technical aspects of the integration, so you can focus on designing your workflow. You can start with pre-built templates or create custom automations in minutes, regardless of your technical background.
Manual video creation with HeyGen requires logging in, entering data for each video, and tracking results separately—a process that can take several minutes per video. With Make's integration, you can process entire spreadsheets automatically, generating dozens or hundreds of videos without any manual intervention. Teams report saving 10-20 hours per week by automating their video workflows. Plus, all video data, URLs, and status updates are automatically logged back to your Google Sheet, giving you instant visibility and eliminating the need for manual record-keeping.
A scenario represents a workflow or a project of your own creation, and it is made up of a series of modules that automate apps and services. Creating a scenario allows you to transfer and transform data between apps and services via these modules to automate anything and improve the way you work.
Modules are the main building blocks of automation in Make. Modules represent actions that Make performs with an app, like creating, updating, or deleting data.
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 350,000+ customers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
Philipp Weidenbach
Head of Operations at Teleclinic
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
Cayden Phipps
COO at Shop Accelerator Martech
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
Erkki Markus
Product Owner at Smaily
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."
Andreas Stryz
CTO & Co-founder at FINN
"I can't count the number of hours I've saved by using Make. Every single day is simpler because of Make's automation."
Kimberly D
Owner of Media Production