Skip to main content

​
Issue Certificates from Google Sheet via Zapier Integration

​
Getting Started with Zapier

Sign up for a free Zapier account, from there you can jump right in. To help you hit the ground running, we have made a pre-made template for Google Sheet and Hyperstack integration.
Screenshot of a deployment confirmation message that says All checks have passed.

​
Setting up Trigger

1

After clicking the above link you will see a prebuilt template like this. Click Trigger to continue setting up the trigger

Screenshot of a deployment confirmation message that says All checks have passed.
2

Click Choose Account to signin with your Google account

Screenshot of a deployment confirmation message that says All checks have passed.
3

Create a Spreadsheet in your Google Sheets and Map the created spreadsheet in Trigger section

Screenshot of a deployment confirmation message that says All checks have passed.
4

Test the trigger - Go to spreadsheet and add first row as heading and rest of the rows with values of the students eg: Name and Email address

Screenshot of a deployment confirmation message that says All checks have passed.
5

Check whether entered rows appear in Zapier test trigger section. After you receive a trigger from Google Sheets click Continue

Screenshot of a deployment confirmation message that says All checks have passed.

​
Setting up Action

1

Associate the Hyperstack account to your zap. Click Choose Account

Screenshot of a deployment confirmation message that says All checks have passed.
2

Enter your Hyperstack API key and click Continue

To obtain your API key: Go to Hyperstack Home > Settings > API Access.
Screenshot of a deployment confirmation message that says All checks have passed.
3

Add Group Key by manually entering the field

Learn how to get your Group Key

Screenshot of a deployment confirmation message that says All checks have passed.
4

Map the Name Google Sheet Column in the Full Name field

Screenshot of a deployment confirmation message that says All checks have passed.
5

Click Continue

Screenshot of a deployment confirmation message that says All checks have passed.
6

Now test a trigger and click Publish to live

This zap will automatically publish certificates to participants when ever a new row gets added. Approximately it will take 1 to 5 mins for each trigger.
If you have any additional questions, you can open a ticket with Zapier Support from https://zapier.com/app/get-help Zapier Troubleshooting Open a ticket with Zapier Support from https://zapier.com/app/get-help
Last modified on February 22, 2026