Back to all templates

Build a monthly Nifty time report in Google Sheets and email it

Generate a monthly Nifty time-tracking report into Google Sheets on schedule.

Description:

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.

Key Features:
  • Monthly schedule trigger
  • Date arithmetic to derive the previous-month reporting period
  • AI-assisted extraction of month name, year, and period boundaries
  • Per-task tracked-time retrieval from Nifty
  • Duration math converting minutes to hours
  • Google Sheets report generation with a total-hours row
  • Email notification with a link to the report
Prerequisites:
  • Nifty connection, with the project ID set in the "Fetch Nifty Tracked Time Report" step
  • Google Sheets connection, with the target spreadsheet selected in the "Create Google Sheet for Report", "Insert Task Data into Google Sheet" and "Add Total Hours Row in Google Sheet" steps
  • OpenAI API key
  • Google Mail connection, with the recipient address set in the "Send Monthly Report Email" step
Ideal For:

Project managers who need an automated monthly time-tracking report for a Nifty project.

STEPS
  1. Trigger: schedule - the first day of every month at 09:00.
  2. Get the current date and subtract one month to derive the reporting period.
  3. Extract the month name, year, and first and last day of the month with OpenAI.
  4. Create a Google Sheet tab for the reporting month with the report headers.
  5. Fetch the tracked-time report for that period from Nifty.
  6. Loop over each tracked task: retrieve task details, compute its duration, convert it to hours, and insert a row into the sheet.
  7. Add a total-hours summary row.
  8. Send an email notification with a link to the report.
COMPONENTS
Schedule
Date Helper
Open Ai
CATEGORYDocument Ops

How ByteChef works?

Focus on what matters,automate the rest.

Copyright © ByteChef. All rights reserved.