Single Task Tools

Rows to Calendar: Create Events from a Spreadsheet

An add-on for Google Sheets™ by Single Task Tools. One task: turn the rows of a spreadsheet into Google Calendar™ events in one run, weekly repeats included, into a calendar of its own. Menus in English, Spanish, Portuguese, French, German and Italian.

Install it from the Google Workspace Marketplace™ (search for “Rows to Calendar”), or from Extensions › Add-ons › Get add-ons inside Google Sheets™.

How to use it

  1. Write your column names in the first row: Title, Start date, Start time, End date, End time, Description, Location, Guests, Repeat, Until (in any of the six languages; only Title and Start date are required). Short names like Date, Time, Event or Where work too. No Title column? The add-on asks which column to use and remembers it.
  2. Open Extensions › Rows to Calendar › Add events (all rows, or only the rows you select).
  3. The events appear in a calendar called “Events from <your sheet>” inside your Google Calendar™, next to your other calendars: one calendar per spreadsheet file, or one per tab if you prefer (Options). Rename it, share it with your team, tick it on your phone. Two columns are added to the sheet, Event ID and Event link.

Privacy first

The add-on asks for one calendar permission only: to create calendars of its own and manage the events in them. It only sees the calendars that this add-on created: your main calendar and your other calendars, yours or shared with you, stay invisible to it and untouched. Putting events straight into an existing calendar needs a wider Google permission; a version with that option is planned.

What you can do

Free and Pro

Free: 100 events a month, with everything above (creating an event counts, also when Update has to create again one that is no longer in the calendar; updating and deleting do not). Reached the month’s 100? The add-on stops and tells you which rows are left: they are created next month, or right away with Pro.

Pro: 29 € once, for each Google account that uses the add-on (the price in your currency is shown at checkout, with a receipt by email; a VAT invoice is available on request). No subscription, no renewal. No monthly limit. If it does not fit, write to us within 14 days and we refund it.

Buy Pro · 29 € once

At checkout, use the email of the Google account where you use the add-on: the code is made for that account and only works there. After paying you receive the code by email (check spam); paste it in Extensions › Rows to Calendar › Pro code…. Didn’t get it? Write to support@singletasktools.com with the email you paid with.

Questions

Can two people use it in the same spreadsheet?
The calendar lives in the Google account that created it. When another person opens the same spreadsheet with their own account and uses the menu, the add-on does not find that calendar there, and it asks before doing anything: Cancel leaves everything as it was. For that person to add, update and delete events from their account too, the owner of the calendar shares it with them in Google Calendar™ with the permission “Make changes and see all event details”. A permission that only lets them see the events is not enough, and some organisations do not allow giving that permission to people outside the organisation. To see the events, sharing the calendar in the usual way is all it takes.
I made a copy of my spreadsheet. What happens with the events?
The copy keeps the Event ID and Event link columns, but those events stay in the calendar of the original spreadsheet. In the copy, Update does not find them: it creates them again in a new calendar named after the copy and tells you how many, and they count as created events. Delete only clears their Event ID in the copy, and says so; the events of the original are not touched. To start the copy from scratch, clear its Event ID column and choose Add events.

Privacy

Nothing leaves your Google account: no servers of ours, no sign-up, no tracking. The add-on only reads the spreadsheet that is open and writes only in the calendars it created. The names in your sheet stay in your Google account. Full policy: privacy · terms.

Support in English, Spanish and Portuguese: support@singletasktools.com.

Google Sheets™ and Google Calendar™ are trademarks of Google LLC. This add-on is not affiliated with Google.