How to Update Google Sheets Row for Resolved Pager Duty Incidents Using Pabbly Connect

Learn how to automate updating Google Sheets rows for resolved Pager Duty incidents using Pabbly Connect. This detailed tutorial covers every step. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start our integration, we will use Pabbly Connect. First, visit the Pabbly Connect homepage by entering ‘Pabbly.com/connect’ in your browser. Here, you can either sign in if you are an existing user or click on ‘Sign up for free’ to create a new account.

Once you create your account, you will receive 100 free tasks every month to explore the features of Pabbly Connect. After signing in, navigate to the ‘All Apps’ section and click on ‘Access Now’ under Pabbly Connect to begin setting up your workflow.

2. Creating a Workflow in Pabbly Connect

In this section, we will create a workflow to update Google Sheets whenever an incident is resolved in Pager Duty. Click on the ‘Create Workflow’ option and give your workflow a name, such as ‘Update Google Sheets Row for Resolved Pager Duty Incidents’. using Pabbly Connect

• Select a folder to save your workflow.
• Click on ‘Create’ to proceed.

After creating the workflow, you will see two windows: one for the trigger and another for the action. In this case, we will select Pager Duty as the trigger application and Google Sheets as the action application. This setup will ensure that when an incident is resolved in Pager Duty, the corresponding row in Google Sheets will be updated automatically.

3. Setting Up the Trigger with Pager Duty

For our trigger, select Pager Duty and set the trigger event to ‘Incident is Resolved’. This means that whenever an incident is resolved in Pager Duty, it will trigger the workflow in Pabbly Connect.

Next, you will receive a webhook URL from Pabbly Connect. Copy this URL and go to Pager Duty. Navigate to the ‘Integrations’ section, select ‘Generic Webhooks’, and click on the ‘Create Webhook’ button.

• Paste the copied webhook URL into the URL field.
• Set the scope type to ‘Service’.
• Provide a description, such as ‘Updating Google Sheets’.
• Deselect all events and select ‘Incident Resolved’.

After completing these steps, click on the ‘Add Webhook’ button to finalize the setup. Now, your webhook is ready to receive responses from Pager Duty when incidents are resolved.

4. Configuring Google Sheets in Pabbly Connect

After setting up the trigger, we will now configure the action to update Google Sheets. Select Google Sheets as the action application and choose the action event ‘Lookup Spreadsheet Row V1’. This allows us to retrieve information from our Google Sheets based on the incident title. using Pabbly Connect

Connect your Google Sheets account by selecting an existing connection or creating a new one. Ensure you are logged into your Google account to authorize the connection. Next, select the spreadsheet containing your incident data, which is named ‘Organization Incidents’.

Set the lookup column to the title of the incidents, which is in column A. Map the lookup value to the incident title received from Pager Duty.

Click on ‘Save and Test Request’ to receive the response from Google Sheets confirming the lookup was successful. This response will include the row index of the incident, which we will use to update the status.

5. Updating the Status in Google Sheets

Now that we have retrieved the row index, we will add another action to update the status in Google Sheets. Select Google Sheets again and choose the action event ‘Update Cell Value’. This will allow us to change the status of the resolved incident.

When prompted, select the same spreadsheet and sheet name. For the range, enter ‘E’ followed by the row index we received from the previous step. This ensures that we are updating the correct row for the incident.

In the value field, enter ‘Resolved’ to update the status. Click ‘Save and Send Test Request’ to finalize the update.

Finally, check your Google Sheets to confirm that the status of the incident has been updated to ‘Resolved’. This completes the integration process using Pabbly Connect, allowing for seamless updates from Pager Duty.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the updating of Google Sheets rows for resolved Pager Duty incidents. By following the steps outlined, you can efficiently manage incident statuses without manual intervention.