How to Integrate Sertifier and Pabbly Connect

(Example integration with Google Sheets) A few step guide on how to Integrate Sertifier and Google Sheets on Pabbly Connect.

Preparation Step: Sertifier

To begin, navigate to the "Advanced" section and select the "Integrations" tab from the menu on the left. Within the Integrations tab, proceed by clicking on "Create New Integration."

image_2024-07-02_011302891


After selecting "Create New Integration," a list of integrations will appear. Choose Pabbly Connect from the list to proceed. Upon clicking Create New Integration, you will be directed to the credential campaign page where you can select or create the components of the credential which are the Design, Detail and the Email Template. 
Screenshot 2024-08-07 at 22.46.12Creating Details

The Credential Details page is where you can input all the essential information for your digital credentials. This section enables you to complete the necessary details for your certificates. Click here for more detailed information on how to create certificate details.

details2

Design Credential

Click the Select Certificate/Badge Design button to choose your preferred design. If you do not have a design yet, you can click on Create New Design to access the Credential Designer. You can click here for more detailed information about the Credential Designer.

image_2024-06-25_204348978

Email Template

The Email Template tab is where you can customize the email that will be sent to your certificate recipients. In this tab, you can customize your mail, and you can find more detailed information here.

email template page

For a complete guide to sending Digital Credentials, you can click here

Preparation Step: Google Sheets

Create a Google Sheets as you wish, but do not forget to add three questions: “First and Last Name", “Email Address” and "Issue Date". That’s it! If you are planning to add more variables to your credentials, please add them to the sheet. For example, if you are going to create a custom variable, you need to create and define a column for it.

Integration On Pabbly Connect

Access your Pabbly Connect account. Locate the "Create Workflow" button on the upper-right corner of the dashboard, click on it and name your workflow.

Screenshot 2024-08-07 at 23.50.51Once you access the workflow editor, you can begin configuring your integration. 

Integration Step: Google Sheets

Click Trigger within the editor and choose Google Sheets. Once you select your integration, choose New or Updated Spreadsheet Row as your trigger event. Then, follow the steps to set up your web hook.

Screenshot 2024-08-07 at 23.55.12

After setting up your web hook, ensure to click on Capture Webhook Response and enter data into your Google Sheet to test the trigger. If the trigger is configured correctly, you should observe the responses being received.

Integration Step: Sertifier

The Action part also has a section for choosing an app and event. Type “Sertifier” into the search box and click on our logo below.

Choose the Add Recipient to Delivery event to automatically issue credentials.

Screenshot 2024-08-08 at 15.46.21

Now you need to select the Add New Connection and type in your Sertifier API Key. You can find your API key in your Sertifier account under Settings > API & Integrations.

Screenshot 2024-08-08 at 15.59.16

Once you type in your API Key, click Save to continue.

Screenshot 2024-08-08 at 15.47.12

Once your connection to your Sertifier account is established, choose the Credential Campaign you created from the Integrations tab and in the Delivery ID field. Select the appropriate answers for each required field (Recipient Name, Recipient Email, Issue Date) in order to accurately link your data. If there are any additional attributes, be sure to also map them accordingly.

Screenshot 2024-08-08 at 15.50.22

Once you've mapped your data, simply click on Save & Test Request to give your workflow a test run. If everything is configured correctly, you should see the message Response Received without any errors. Congratulations on successfully completing the setup of your Pabbly Connect integration!

Screenshot 2024-08-08 at 15.53.15