Build a monthly Nifty time report in Google Sheets and email it
Generate a monthly Nifty time-tracking report into Google Sheets on schedule.
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.
- 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
- Nifty connection with the project ID configured
- Google Sheets connection with the target spreadsheet
- OpenAI API key
- Google Mail connection
Project managers who need an automated monthly time-tracking report for a Nifty project.
- Trigger: schedule - the first day of every month at 09:00.
- Get the current date and subtract one month to derive the reporting period.
- Extract the month name, year, and first and last day of the month with OpenAI.
- Create a Google Sheet tab for the reporting month with the report headers.
- Fetch the tracked-time report for that period from Nifty.
- Loop over each tracked task: retrieve task details, compute its duration, convert it to hours, and insert a row into the sheet.
- Add a total-hours summary row.
- Send an email notification with a link to the report.
MoreDocument OpsTemplates
Trim columns from a CSV file in AWS S3 and upload the result
Retrieves an offices.csv object from AWS S3, reads it into rows, and loops over each row keeping only four selected columns. The reduced rows are collected into a list, written to a new CSV file, and uploaded back to S3 as offices_reduced.csv. The workflow runs on demand.
Delete a sheet from a Google Sheets spreadsheet
Deletes a specific sheet from a Google Sheets spreadsheet and logs the result. A minimal, on-demand example workflow.
List all sheets in a Google Sheets spreadsheet
Lists all sheets in a Google Sheets spreadsheet and logs them. A minimal, on-demand example workflow.
Validate CSV rows and insert them into PostgreSQL
Reads a local cities.csv file, parses it, and loops over each row. Rows with both a City and a State value are logged and inserted into the PostgreSQL CITY table; rows missing either value are logged as warnings. After the loop, it queries the row count of the CITY table and logs the total.
How ByteChef works?
Focus on what matters,automate the rest.
By subscribing, you agree to receive emails from ByteChef and to our Privacy Policy. You can unsubscribe at any time.