To create Spreadsheet File records from PagerDuty without manual input, use a ready-made scenario.
You can launch this PagerDuty + Spreadsheet File integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.