This template runs on a monthly schedule, computes a period label and timestamps in JavaScript, and appends that row to Google Sheets.
Use it as a ledger of month boundaries for reporting or close. Connect Google Sheets, then set the schedule to the first day of the month in your accounting timezone.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
A schedule starts the scenario on the first day of each month, in the timezone you set.
JavaScript returns yyyy-MM, a readable label, and start and end timestamps for that month.
Google Sheets writes those fields as a new row on the tab you choose.
Add a schedule for the first day of each month. Match the timezone you use for books.
Add a Google Sheets connection. Use a tab with columns for period, label, start, and end.
Add a JavaScript node. Return yyyy-MM, a label, and timezone-safe start and end timestamps, then add a single row in Sheets. Run once by hand before you go live.
FAQ
More templates
This template runs on a schedule, opens each URL in a headless browser, and compares visible text to the last snapshot in Latenode Database. When the change crosses your threshold, JavaScript builds RSS XML and Google Drive saves the feed file. Connect Google Drive. Keep snapshots in Latenode Database keyed by URL.
This template receives Cognito Forms submissions on a Latenode webhook, maps the payload, then creates or updates the contact in ActiveCampaign and applies a tag. Paste the webhook URL into Cognito Forms. Connect ActiveCampaign and put the API URL and key on that connection. Map email so matches update the same person.
This template watches a Discord channel for new messages, translates the text with Google Cloud Translate, and posts the translation back to Discord. Connect a Discord bot and Google Cloud Translate. Put the Translate API key on the Google Cloud Translate connection. Point the trigger at the channel you want to translate and pick the target language.
