#
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
To obtain your API key: Go to Hyperstack Home > Settings > API Access.
Step 3: Add Group Key by manually entering the field.
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
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