#Google Sheets

2 posts tagged Google Sheets

Auto-Routing a Report to the Right Owner with a Spreadsheet Lookup

A report form sends a URL. The bot normalizes the URL, looks it up in a master spreadsheet to find who owns that page, and @mentions them in-thread, with sensible fallbacks. Covers URL normalization, an efficient bottom-up sheet lookup, and Slack mention resolution including subteam groups.

PythonSlackGoogle Sheets

From a Slack Form to a Spreadsheet Row and a Calendar Event

5 min read

Parsing a multi-field Slack Workflow form into structured data, appending it to a Google Sheet, posting a review message with an Approve button, and on approval booking a Google Calendar event. Covers form parsing, the Sheets API, Slack interactive buttons, and the Calendar API.

PythonSlackGCPGoogle Sheets