Integrate Google Sheets into your AI workflows

When a Google Forms response is submitted, downloads the attached CV PDF from Google Drive, extracts its text, and summarizes it with AI. OpenAI scores the candidate from 0 to 10 against a Senior Java Developer job description. The name, email, summary, and score are recorded in a Google Sheet, and the CV file is filed into a Rejected or Potential candidates Google Drive folder based on the score.

Deletes a specific sheet from a Google Sheets spreadsheet and logs the result. A minimal, on-demand example workflow.

Lists all sheets in a Google Sheets spreadsheet and logs them. A minimal, on-demand example workflow.

On the first day of every month at 09:00, computes the previous month, creates a new Google Sheet tab for it, and fetches the tracked-time report from Nifty. It loops over each tracked task to retrieve details and compute its duration in hours, writes a row per task, adds a total-hours row, and emails a notification with a link to the spreadsheet.

On every new Gmail message, checks whether it arrived within business hours (Mon-Fri, 09:00-17:00 UTC). For emails received outside working hours, OpenAI classifies the urgency, the email is logged to a Google Sheet, and a condition branches: urgent emails get an AI-summarized internal Slack alert plus an urgent auto-reply, while non-urgent emails get an AI-generated helpful auto-reply.