Skip to content

Python script that sends PagerDuty incidents to a sheet in Smartsheet

License

Notifications You must be signed in to change notification settings

PagerDuty-Samples/pagerduty-incidents-to-smartsheet

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 

Repository files navigation

PagerDuty Incidents to Smartsheet

This is a Python script that sends PagerDuty incidents to a sheet in Smartsheet. The script adds new incidents to the bottom of the sheet, and updates any existing incident already in the sheet.

This is very basic. The update only checks if the incident id is already in the sheet, and then updates the entire row no matter if there are any changes in the incident.

Dependencies

This script relies on the PDPYRAS: PagerDuty Python REST API Sessions as well as the Smartsheet Python SDK. Before using the script please install both of those libraries using PIP.

pip install pdpyras
pip install smartsheet-python-sdk

Instructions

  1. Create a sheet, and get the Sheet ID from File->Sheet Properties in the Smartsheet UI.
  2. As the code stands right now, it relies on the names of the columns in the sheet to put the PagerDuty information in the correct cells. Currently, the names of the columns are as follows:
  • ID
  • Number
  • Incident
  • Description
  • Created At
  • Status
  • Service
  • On Call

If you change the names of the columns in the sheet, then make changes to the code around lines 66-108.

  1. Set your value for smartsheet_token on line 10.
  2. Set your value for sheet_id on line 12.
  3. Set your value for pypd.api_key on line 14.

About

Python script that sends PagerDuty incidents to a sheet in Smartsheet

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages