Can You Insert Google Calendar into Sheets? (Yes, Here’s How)

If you’re managing projects, content schedules, or marketing campaigns in Google Sheets, you’ve probably wondered: Can I insert my Google Calendar into Sheets? The answer is yes—with a few simple steps, you can sync your calendar events right into Google Sheets.

Whether you're organizing team meetings, editorial calendars, or planning social media content, this integration can save time and reduce the risk of double bookings or missed tasks.

Let’s walk through the process step-by-step.

How to Insert Google Calendar into Google Sheets

Step 1: Open Your Google Calendar

1. Go to Google Calendar.
   
2. On the left panel, under My calendars , find the calendar you want to insert into Sheets.
   

Step 2: Make the Calendar Public (Optional but Necessary for Sharing)

1. Hover over the calendar name and click on the three-dot menu (Options).
   
2. Select Settings and sharing .
   
3. Scroll down to Access permissions for events and check the box Make available to the public (Note: Use this option carefully if your calendar includes sensitive info).
   

Step 3: Get the Calendar’s Public iCal Link

1. In the same settings menu, scroll to Integrate calendar .
   
2. Copy the Public address in iCal format . It will end in .ics.
   

Step 4: Use Google Apps Script in Google Sheets

1. Open a new Google Sheet.
   
2. Click Extensions > Apps Script .
   
3. Replace the placeholder code with the following script:
   

javascript

CopyEdit

function importCalendar() {

var calendarUrl = "YOUR_CALENDAR_ICS_LINK_HERE";

var response = UrlFetchApp.fetch(calendarUrl);

var data = response.getContentText();

var events = data.match(/BEGIN:VEVENT[\s\S]*?END:VEVENT/g);

var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

sheet.clear();

sheet.appendRow(["Summary", "Start Date", "End Date"]);

for (var i = 0; i < events.length; i++) {

var summary = events[i].match(/SUMMARY:(.*)/)[1];

var start = events[i].match(/DTSTART.*:(.*)/)[1];

var end = events[i].match(/DTEND.*:(.*)/)[1];

sheet.appendRow([summary, start, end]);

}

}

1. Replace YOUR_CALENDAR_ICS_LINK_HERE with your copied iCal URL.
   
2. Click the disk icon to save the script.
   
3. Run the function by clicking the play ▶️ button.
   

You may need to authorize the script to run the first time.

Step 5: Automate It (Optional)

Set a trigger to automatically pull in new events every day:

1. Go to the clock icon in Apps Script (Triggers).
   
2. Click Add Trigger > Select importCalendar > Choose your frequency.
   

Streamline Your Content Scheduling

If you're publishing blogs or managing multiple campaigns, Google Sheets + Calendar can keep everything aligned. To make content publishing even easier, use Docswrite.com—a website that lets you publish from Google Docs directly to WordPress without plugins. It’s perfect for marketers, writers, and agencies managing high-volume content.

FAQ: Google Calendar + Sheets

Can you insert Google Calendar into Google Sheets automatically?
Yes, by using Google Apps Script, you can fetch events automatically via the calendar’s iCal link.

Is it safe to make a Google Calendar public?
Only make calendars public if they don’t contain private information. For internal team use, consider sharing with specific users instead.

Do I need any plugins to sync Sheets with Calendar?
No plugins are required—just a Google Calendar iCal link and a custom Apps Script.

How often can I refresh the calendar data in Sheets?
You can run the script manually or set up an automatic trigger (e.g., daily or hourly).

What’s Docswrite and how does it help?
is a web-based tool that helps you publish content directly from Google Docs to WordPress —perfect for content marketers who want to streamline their workflow without needing any plugin installations.