LEARNTEC 2027Meet Virtualbadge.io in Karlsruhe in February 2027.Book a meeting at our stand
How-to guide

Zapier and Google Sheets: new row, new certificate

Every new row in your spreadsheet becomes a recipient and a credential. This is how you connect sign-up forms, shops and course management tools without any development of your own. This guide shows every step in Virtualbadge.io.

20 minFor issuersUpdated November 2026
At a glanceGuide
in 5 steps
Time
about 20 minutes
For
Issuers
Where
Account Settings Integrations Zapier
Plan
Advanced and Professional
What you need
  • A Zapier account
  • A Google Sheets spreadsheet with name and email address
  • An active template

No account yet? Start a free trial. It runs for seven days.

Zapier connects Virtualbadge.io with other applications. A trigger supplies the name and email address; Virtualbadge.io adds the person to the template and issues the credential. The integration depends on your plan.

Step 1: Set the template to active

Create the template and complete all steps. The overview must show the status “Active”. Only active templates can be selected in Zapier.

The template's overview: the status “Active” sits next to “Pause”.

Step 2: Find the integration

Under “Settings” and “Integrations” you see the cards for Zapier, Google Sheets, Google Forms and Typeform among the third-party integrations. “Connect” leads to the setup in Zapier, “Learn More” to the description.

Zapier and the templates for Google Sheets and Google Forms.

Step 3: Create a Zap with a trigger

Create a new Zap in Zapier. Any application that supplies the person's name and email address works as a trigger, for example a new row in Google Sheets or a new entry in Typeform.

Step 4: Choose Virtualbadge.io as the action

Choose Virtualbadge.io as the action, sign in with your account and select the active template. You do not need an API token for this.

Tip

If Zapier asks for a token, check that the app “Virtualbadge.io” is really the one selected.

Step 5: Map the fields, test and switch on

Map the trigger's fields to the template's fields: name, email address and your dynamic fields. First and last name can be combined into one name.

Test the Zap with one row and switch it on. Every new row then adds a person, and the credential is created and sent automatically.

Follow this guide with your own data.

Check the result

  • A test row in the spreadsheet creates an entry in the list of recipients.
  • Name and dynamic fields are correct on the credential.
  • The email has reached the test address.

More on this: Zapier IntegrationIntegrations

Frequently asked questions

Do I need an API token for Zapier?

No. You sign in to Zapier with your Virtualbadge.io account.

Is the email sent automatically?

Yes. When the Zap runs, the credential is created and sent without you logging in.

Where do I manage the connection?

Under “Settings”, “Integrations”, among the third-party integrations.

Does this work without Zapier?

Yes. From your own system you add recipients with the REST API. For courses in Moodle there is the plugin for Moodle. For single courses, the CSV list is enough.

Where to go next

Try it with your own certificate

Upload your current certificate design, issue a test credential and follow the guides with real data. The trial runs for seven days.

More than 1,000 organizations issue with Virtualbadge.io, including telc, Vodafone, Dell, IDP, EBS Universität and Mannheim Business School.