Watch Step By Step Video Tutorial Below





1. Setting Up Pabbly Connect for Event Automation

To begin automating ticket delivery, access Pabbly Connect by visiting pabbly.com/connect. Create a free account to start using the platform’s automation capabilities.

Once logged in, you will see the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button to start setting up your automation. You can name your workflow, for instance, ‘Automate Ticket Delivery for Paid Attendees’.

2. Connecting Google Sheets with Pabbly Connect

In this step, we will set Google Sheets as the trigger application in Pabbly Connect. Select Google Sheets and the event as “New or Updated Spreadsheet Row”. This means that every time a new row is added, it will trigger the automation.

Next, click on the connect button to obtain a webhook URL. You will need this URL to link your Google Sheets with Pabbly Connect. Follow these steps to set it up:

  • Go to Google Sheets and select Extensions.
  • Click on Add-ons, then Get Add-ons, and search for Pabbly Connect Webhooks.
  • Install the Pabbly Connect Webhooks add-on.

After installation, click on the add-on and set up the webhook by pasting the copied URL. Ensure that the trigger column is set correctly (e.g., column K). This setup allows Pabbly Connect to receive data from your Google Sheets seamlessly.

3. Generating Tickets with PDF Monkey through Pabbly Connect

Next, we will set up PDF Monkey as the action application in Pabbly Connect. This step is crucial for generating personalized tickets for each attendee. Choose PDF Monkey and set the event as “Custom API Request”.

Click on the connect button and enter your API token from your PDF Monkey account. After connecting, set the request method to POST, which allows you to send attendee data to PDF Monkey. You will need the API endpoint URL from PDF Monkey’s documentation.

  • Select JSON as the payload type.
  • Map the required fields such as ticket ID, attendee name, and event details using the data received from Google Sheets.

Mapping these fields is essential as it ensures that each ticket generated is personalized based on the attendee’s information.

4. Sending Tickets via WhatsApp Using Pabbly Chat Flow

Now, select Pabbly Chat Flow as your next action application in Pabbly Connect. This application will send the generated ticket directly to the attendee’s WhatsApp. Choose the event as “Send Document” and connect your account.

In the setup, you will map the WhatsApp number of the attendee, ensuring that the message is sent to the correct recipient. Enter the document URL that was generated by PDF Monkey. This will include the ticket PDF link in the WhatsApp message.

  • Map the WhatsApp number and ensure it includes the country code.
  • Personalize the message content to include the attendee’s name and ticket details.

Once you have configured these settings, test the workflow by sending a message. You should receive a confirmation that the message was sent successfully, indicating that your automation is working correctly.

5. Finalizing the Automation with Pabbly Connect

To complete your automation, return to Google Sheets and ensure the send-on-event feature is active. This setting allows Pabbly Connect to automatically receive new data entries from the sheet.

Click on the “Send All Data” button in the Pabbly Connect Webhooks add-on to test if the automation works for multiple attendees. You should see that each attendee receives their personalized ticket on WhatsApp.

This demonstrates the power of Pabbly Connect in automating ticket delivery. By following these steps, you can efficiently manage ticketing for events without manual intervention.

Conclusion

Using Pabbly Connect, Google Sheets, and WhatsApp, you can automate ticket delivery seamlessly. This tutorial simplifies the process, allowing you to focus on organizing successful events without repetitive tasks.