Help

Short answers to common questions (pricing, duplicates, guests, privacy) are on the FAQ page.

Setting up your sheet

One row per event, with a header row. Calrows guesses the mapping from header names, and you can change it in the sidebar.

Column	Required	Accepted values
Title	Yes	Any text
Start	Yes	A date or date-time cell. Format the column as Date time so Sheets stores a real date
End	No	Date-time. If blank, the default length from the sidebar is used (60 minutes unless you change it)
All day	No	TRUE, yes, or a ticked checkbox. Multi-day all-day events use Start and End dates
Description, Location	No	Any text
Guests	No	Email addresses separated by commas
Color	No	blue, green, red, yellow, orange, purple, cyan, grey, pink, lavender, sage, or a number 1 to 11

Extensions › Calrows › Insert sample sheet gives you a working example.

Sending rows to Calendar

Pick the calendar, check the mapping, click the green button. A hidden column named _eventId is added to your sheet. It links each row to its event so that running again updates instead of duplicating. Don't delete it: if a sheet that was already synced loses that column, Calrows refuses to send rather than create every event a second time. Undo the deletion (Ctrl+Z or File › Version history) to carry on, or copy the rows into a new tab if you really want fresh events.

Pulling changes from Calendar

Updates the mapped columns of every linked row from the current event. Rows whose event was deleted in Calendar get a note on the ID cell.

Removing events for deleted rows

Deletes events Calrows created for rows that no longer exist in the sheet. It never touches events it did not create. You are asked to confirm.

Importing from Calendar

Choose a calendar and a date range. A new tab is created with the events, already mapped, so you can edit and send them back.

Timesheets

Pick a range, optionally a word the titles must contain (a client name, for example), and a rate. You get hours and amounts per event, a total, and a per-title summary. All-day events are excluded.

Automatic sync (Pro)

Runs "Send rows" on a schedule for the sheet selected when you turned it on, optionally followed by a pull and a removal. It runs as your account, in the background. Turn it off from the same section.

Limits

Free plan: 50 new events a month, imports and timesheets of up to 50 events at a time. Counted per Google account.
Google itself limits calendar operations per day. Very large syncs may pause and continue automatically. The Sync Log will say so.
The sidebar is not available in the Google Sheets™ mobile apps. Set things up on a computer; automatic sync keeps running everywhere.

Common errors

Message	Meaning
Start is not a date	The cell is text, not a date. Format the column as Date time and re-enter the value
End must be after start	End equals or precedes Start. Fix it or leave End blank
Calendar not found or no access	The calendar was removed or you only have read access to it
Free plan limit reached	50 new events this month already. Upgrade or wait for next month
Your administrator needs to approve this app / Calrows is blocked	Your Google Workspace organisation only allows approved add-ons. Send your admin calrows.com/admins: it has the two-minute approval steps

Things to know

Recurring events are read-only. Imports list each occurrence without an event ID, and Calrows will not edit or delete a repeating series. Manage those in Google Calendar directly.
Remove events for deleted rows only ever deletes events Calrows itself created from that sheet. Events you imported from a calendar are never deleted by it. If the hidden _eventId column is missing, the button refuses to run rather than guess.
Automatic sync is locked to the sheet, calendar and column mapping you had selected when you turned it on. Importing or pulling on another tab does not change what the timer syncs.
Time zones: all-day dates follow your spreadsheet's time zone (File › Settings). If a date lands a day off, check that setting matches where you are.
Dates must be real date cells. A time without a date, or a plain number, is skipped with a message in the Sync Log rather than turned into an event in 1899.
Google rate limits: creating hundreds of events quickly can trigger Google Calendar's own throttle. Calrows stops with "rate-limiting" and continues from the same row when you run it again a few minutes later. No free-plan credit is used for a failed creation.

Receipts, renewing and older subscriptions

Pro is a one-time payment for 1 month or 1 year and never renews, so there is nothing to cancel. The sidebar shows the date your Pro ends. To keep Pro, buy again on the pricing page; the new time is added to what you have left.

Receipts and invoices are in the Paddle customer portal; sign in with the email you used at checkout. If you bought a subscription before 23 September 2026, you can cancel it there too; Pro stays active until the end of the period you paid for, then the add-on returns to the Free plan.