# 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.


# Setting up Trigger

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

Step 2: Click Choose Account to signin with your Google account

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

Step 4: Testing trigger, Go to spreadsheet and first row as heading and rest of the rows with values of the students eg: Name and Email address

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

# Setting up Action

Step 1: Associate the Hyperstack account to your zap. Click Choose Account

Step 2: Enter your Hyperstack API key and click Continue

Step 3: Add Group Key by manually entering the field.

Learn how to get your Group Key
../zapier-integration/

Step 4: Map the Name Google Sheet Column in the Full Name field

Step 5: Click Continue

Step 6: Now test a trigger and click Publish to live



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