Watch Step By Step Video Tutorial Below
1. Accessing Pabbly Connect for Integration
To start integrating JSON with Google Sheets, you first need to access Pabbly Connect. This platform enables seamless automation without any coding. Begin by logging into your Pabbly Connect account.
Once logged in, navigate to the workflow builder where you will set up your integration. In this section, you will define two crucial steps: the trigger and the action. The trigger detects an event, while the action performs a specific task based on that trigger.
2. Setting Up the Trigger with Google Sheets
In this step, you will configure the trigger using Google Sheets. Select Pabbly Connect as your trigger application and choose the event labeled “New or Updated Spreadsheet Row.” This ensures that whenever a new entry is added to your Google Sheet, the automation will be activated.
- Select “Google Sheets” as the trigger application.
- Choose “New or Updated Spreadsheet Row” as the event.
- Click on the “Connect” button to establish a connection.
After clicking on the connect button, you will receive a webhook URL. This URL is essential for linking your Google Sheet with Pabbly Connect. Copy this URL and head over to your Google Sheet to set up the connection.
3. Connecting Google Sheets to Pabbly Connect
To connect your Google Sheet to Pabbly Connect, click on the “Extensions” menu and select “Add-ons.” From there, choose “Get Add-ons” and search for “Pabbly Connect Webhook.” Install this add-on to facilitate the connection.
Once installed, click on the Pabbly Connect Webhook option and select “Initial Setup.” Here, paste the webhook URL you copied earlier. You will also need to specify the trigger column, which indicates the final data column in your sheet. For example, if you want to send payment status, enter the column letter where this information resides.
4. Generating Invoice with PDF Monkey
After setting up the trigger, the next step involves generating the invoice. Choose Pabbly Connect as your action application and select “PDF Monkey” to create the invoice document. Set the event to “Generate Document” to initiate the invoice generation process.
- Select “PDF Monkey” as the action application.
- Choose “Generate Document” as the event.
- Connect using your existing PDF Monkey account or create a new connection.
After establishing the connection, enter the template ID for the invoice you created in PDF Monkey. This ID is essential for generating the invoice correctly. After mapping the necessary fields, click on “Save and Send Request” to generate the invoice.
5. Updating Google Sheets with Invoice Link
Finally, to keep your Google Sheet updated, you will add the generated invoice link back into the sheet. Select Pabbly Connect as your action application again and choose “Google Sheets” as the action event, this time selecting “Update Row.”
Map the generated PDF link to the appropriate column in your Google Sheet. This ensures that the link to the newly created invoice is automatically updated in the correct row of your sheet. After completing the mapping, click on “Save and Send Request” to finalize the update.
Conclusion
In this tutorial, we demonstrated how to use Pabbly Connect to integrate JSON and Google Sheets for automated invoicing. By following these steps, you can streamline your invoicing process efficiently.



