Automatically Generate Event Passes Using Pabbly Connect, MS Excel & Passcreator

Learn how to automatically generate event passes using Pabbly Connect, Microsoft Excel, and Passcreator in this detailed tutorial. Follow the exact steps to integrate these applications.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Event Pass Generation

To automatically generate event passes, the first step is accessing Pabbly Connect. You can do this by visiting the Pabbly Connect website and signing up for a free account if you don’t have one.

Once logged in, click on the ‘Access Now’ button under Pabbly Connect to reach the dashboard. Here, you’ll find the option to create workflows that integrate Microsoft Excel with Passcreator, allowing you to automate the pass generation process.

2. Creating a Workflow in Pabbly Connect

Creating a new workflow in Pabbly Connect is essential for setting up the automation. Click on the ‘Create Workflow’ button and name it appropriately, such as ‘Automatically Generate Event Passes using Microsoft Excel and Passcreator’. This gives clarity to your workflow’s purpose.

• Select a folder to save your workflow.
• Set up the trigger application as Microsoft Excel.
• Choose the trigger event as ‘New Row in Worksheet’.

By setting this workflow, you ensure that every time a new entry is added in Microsoft Excel, it will trigger the action to generate a pass in Passcreator.

3. Connecting Microsoft Excel to Pabbly Connect

To connect Microsoft Excel with Pabbly Connect, you need to establish a connection after selecting the trigger event. Click on ‘Connect’, then choose ‘Add New Connection’. You will be prompted to log into your Microsoft Excel account and grant access.

Once connected, select the workbook and worksheet containing your event pass data. For example, if your workbook is named ‘Event Passes’ and your worksheet is ‘Sheet1’, make sure to select them accordingly. After selecting, save your settings to ensure the connection is stable.

4. Setting Up the Action in Passcreator

The next step involves setting up the action in Passcreator through Pabbly Connect. After configuring your trigger, select Passcreator as the action application. Click on ‘Connect’ and then ‘Add New Connection’ to enter your API key from Passcreator.

• Log into Passcreator, navigate to ‘Integration’, and then ‘API Keys’ to generate a new key.
• Copy the API key and paste it into Pabbly Connect.
• Select the action event as ‘Create Wallet Pass’.

Completing these steps will allow you to create customized passes based on the data received from Microsoft Excel.

5. Mapping Data and Generating Passes

Mapping the data from Microsoft Excel to Passcreator is crucial in Pabbly Connect. After selecting the template for your pass, you will need to map fields such as first name, last name, and email address from the Excel sheet to the corresponding fields in Passcreator.

After mapping the details, click on ‘Save and Send Test Request’. This will generate a pass based on the data provided. If successful, you will receive a confirmation response indicating that the pass has been created. You can then check the created passes in your Passcreator account.

Conclusion

In this tutorial, we explored how to automatically generate event passes using Pabbly Connect, Microsoft Excel, and Passcreator. By following the exact steps outlined, you can streamline your event management process, ensuring that every attendee receives their customized pass efficiently.