Publishing posts from a spreadsheet — with confirmations and failure alerts

The scenario takes pending posts from Google Sheets, publishes them to Facebook Graph API and immediately reports back: success sends a note to Slack and an email to Send Email; failure raises an alert and flags the row.

  • Only the posts actually waiting in the queue go out
  • Success is reported both to Slack and Send Email
  • A failure never passes silently — the alert names the reason
  • Every post in Google Sheets carries its own status