# Google sheet to Google calendar

**URL:** <https://community.n8n.io/t/google-sheet-to-google-calendar/138485>\
**Category:** Questions\
**Created:** [June 25, 2025, 1:46pm UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485 "2025-06-25T13:46:51Z")\
**Posts on this page:** 18\
**Page:** 1

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [June 25, 2025, 1:46pm UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/1 "2025-06-25T13:46:51Z")

</div>

Hello, I am an new and beginner on n8n.

I created workflow for get event from Google sheet to Google Calendar as below;

 ![Screenshot 2025-06-25 202655](https://europe1.discourse-cdn.com/n8n/original/3X/c/a/cab4f7d5adeaa725de88543d267899a3da8da408.png)

Google sheet :  
Event Name | Description | Start Date | End Date | Start Time | End Time | Reminder Minutes

When I fill an reminder (before event 1 week) it is work ,so in the calendar added it  
But I want to add more remainders ( before event 10 mins, 1 week), it cannot add them.

What shoule I do? 🤔 Colud you help me.

Thanks in advance 🙏

\*n8n version: Version 1.91.3 and run on desktop

---

<div class="post-metadata">

**Author:** ![jabbson](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jabbson/32/87328_2.png) [@jabbson](https://community.n8n.io/u/jabbson)\
**Post date:** [June 25, 2025, 3:50pm UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/2 "2025-06-25T15:50:45Z")

</div>

You can uncheck Set default reminders and configure your own:

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/c/3/c3857295563a0999b41e84463eba60d08d6fb963.png)

---

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [June 26, 2025, 1:25am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/3 "2025-06-26T01:25:32Z")

</div>

thank you for your help.

I forgot inform that at the reminders.  
When I have 2 events, the first remind 10, 1week and the second remind 30, so there are the problem with google calendar node.

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/3/0/300c7ad0671a5c78df2b3353bdeafa49d9bcb0fa.png)

I try to fix in this node but it is alway error.

---

<div class="post-metadata">

**Author:** ![jabbson](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jabbson/32/87328_2.png) [@jabbson](https://community.n8n.io/u/jabbson)\
**Post date:** [June 26, 2025, 1:33am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/4 "2025-06-26T01:33:08Z")

</div>

Do both input jsons have data to fill in the reminder values in the Calendar node?

---

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [June 26, 2025, 1:35am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/5 "2025-06-26T01:35:32Z")

</div>

yes, Json have the data

---

<div class="post-metadata">

**Author:** ![jabbson](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jabbson/32/87328_2.png) [@jabbson](https://community.n8n.io/u/jabbson)\
**Post date:** [June 26, 2025, 1:57am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/6 "2025-06-26T01:57:44Z")

</div>

Well, I don’t know what could be the reason. If you want to give me an example sheet values (which I can copy) and [embed](https://europe1.discourse-cdn.com/n8n/original/3X/e/a/eae673d3accccf98cc6777fb3ba814bd47ed888f.gif) your workflow for me to copy and try myself, I can take a look.

---

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [June 26, 2025, 6:37am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/7 "2025-06-26T06:37:12Z")

</div>

Here is JSON workflow and I have to hind my informations (Pls understand me)

Thank you very much

Google sheet

| Event Name | Description | Start Date | End Date | Start Time | End Time | Reminder Minutes |
| --- | --- | --- | --- | --- | --- | --- |
| name.com1 | ctpcrm.tech | 2025-06-29 | 2025-06-29 | 10:00 | 18:00 | 10,1week |
| name.com2 | ctpcrm.tech | 2025-06-29 | 2025-06-29 | 10:00 | 18:00 | 30 |

 ![Screenshot 2025-06-26 133541](https://europe1.discourse-cdn.com/n8n/original/3X/7/1/710ed9d58370d29c9ed925edb345266f4885b20d.png)

---

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [June 26, 2025, 6:41am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/8 "2025-06-26T06:41:32Z")

</div>

Pls see above post 🙏

---

<div class="post-metadata">

**Author:** ![Wouter\_Nigrini](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/wouter_nigrini/32/150261_2.png) [@Wouter\_Nigrini](https://community.n8n.io/u/Wouter_Nigrini)\
**Post date:** [June 26, 2025, 11:16am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/9 "2025-06-26T11:16:44Z")

</div>

If you are trying to set a dynamic amount of reminders for each event, then you might have to use the Google Calendar API directly using a http node. Im not sure you can set a dynamic amount of reminders using the Google Canlendar node directly.

---

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [June 27, 2025, 12:11pm UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/10 "2025-06-27T12:11:44Z")

</div>

Here again

```auto
(https://drive.google.com/file/d/1dv5zx1ppmmB5jaZPOtFfdsFbV_FjCGWc/view?usp=sharing)

```

Thank you

---

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [June 27, 2025, 12:15pm UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/11 "2025-06-27T12:15:15Z")

</div>

I try to use Google Canlendar node, first. Also using HTTP node. But I cannot do it. 😅

---

<div class="post-metadata">

**Author:** ![jabbson](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jabbson/32/87328_2.png) [@jabbson](https://community.n8n.io/u/jabbson)\
**Post date:** [June 27, 2025, 2:09pm UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/12 "2025-06-27T14:09:35Z")

</div>

Would you like to share the workflow you tried with http node, which didn’t work?

---

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [June 30, 2025, 8:08am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/13 "2025-06-30T08:08:50Z")

</div>

Here this HTTP node 😅

{  
“nodes”: [  
{  
“parameters”: {  
“pollTimes”: {  
“item”: [  
{  
“mode”: “everyMinute”  
}  
]  
},  
“documentId”: {  
“\_\_rl”: true,  
“value”: “{{Google Sheet ID}}”,  
“mode”: “list”,  
“cachedResultName”: “{{Google Sheet name}}”,  
“cachedResultUrl”: “{{Google Sheet url}}”  
},  
“sheetName”: {  
“\_\_rl”: true,  
“value”: “gid=0”,  
“mode”: “list”,  
“cachedResultName”: “sheet”,  
“cachedResultUrl”: “{{Google Sheet url}}”  
},  
“event”: “rowAdded”,  
“options”: {}  
},  
“type”: “n8n-nodes-base.googleSheetsTrigger”,  
“typeVersion”: 1,  
“position”: [  
-420,  
-160  
],  
“id”: “34b2fa08-4ba1-40db-9fd2-a53320806940”,  
“name”: “Google Sheets Trigger”,  
“credentials”: {  
“googleSheetsTriggerOAuth”: {  
“id”: “{{Google Sheets Trigger ID}}”,  
“name”: “{{Google Sheets Trigger}}”  
}  
}  
},  
{  
“parameters”: {  
“jsCode”: “function padTime(timeStr) {\n const [h, m] = timeStr.split(‘:’);\n return `${h.padStart(2, '0')}:${m.padStart(2, '0')}`;\n}\n\nfunction parseReminders(input) {\n const reminders = ;\n const reminderParts = String(input).split(‘,’).map(part =\> part.trim().toLowerCase());\n for (const part of reminderParts) {\n let minutes;\n const num = parseInt(part);\n if (part.includes(‘week’)) minutes = num \* 7 \* 24 \* 60;\n else if (part.includes(‘day’)) minutes = num \* 24 \* 60;\n else if (part.includes(‘hour’)) minutes = num \* 60;\n else minutes = num || 10;\n if (!isNaN(minutes)) {\n reminders.push({\n method: ‘popup’,\n minutes: minutes\n });\n }\n }\n return reminders; //.length \> 0 ? reminders : [{ method: ‘popup’, minutes: 10 }];\n}\n\nconst eventsToCreate = ;\nfor (const row of $input.all()) {\n const reminderInput = row.json[‘Reminder Minutes’] || ‘10’;\n const reminders = parseReminders(reminderInput);\n const startDate = row.json[‘Start Date’];\n const startTime = padTime(row.json[‘Start Time’]);\n const endDate = row.json[‘End Date’];\n const endTime = padTime(row.json[‘End Time’]);\n const eventData = {\n summary: row.json[‘Event Name’],\n description: row.json[‘Description’] || ‘’,\n start: {\n dateTime: `${startDate}T${startTime}:00`,\n timeZone: ‘Asia/Bangkok’,\n },\n end: {\n dateTime: `${endDate}T${endTime}:00`,\n timeZone: ‘Asia/Bangkok’,\n },\n reminders: {\n useDefault: false,\n overrides: reminders.slice(0, 5) // Google Calendar รองรับ max 5 overrides\n },\n };\n eventsToCreate.push({ json: eventData });\n}\nreturn eventsToCreate;\n”  
},  
“type”: “n8n-nodes-base.code”,  
“typeVersion”: 2,  
“position”: [  
-240,  
-160  
],  
“id”: “62477d01-3078-4954-aca0-ac305a45cb05”,  
“name”: “Code”  
},  
{  
“parameters”: {  
“method”: “POST”,  
“url”: “{{Google CalendarOAuth url}}”,  
“authentication”: “predefinedCredentialType”,  
“nodeCredentialType”: “{{googleCalendarOAuth}}”,  
“sendBody”: true,  
“specifyBody”: “json”,  
“jsonBody”: “={\n \"summary\": \"={{ $json.summary }}\",\n \"description\": \"={{ $json.description }}\",\n \"start\": { \"dateTime\": \"={{ $json.start.dateTime }}\", \"timeZone\": \"Asia/Bangkok\" },\n \"end\": { \"dateTime\": \"={{ $json.end.dateTime }}\", \"timeZone\": \"Asia/Bangkok\" },\n \"reminders\": {\n \"useDefault\": false,\n \"overrides\": {{ JSON.stringify($json.reminders.overrides) }}\n }\n }"\n}”,  
“options”: {}  
},  
“type”: “n8n-nodes-base.httpRequest”,  
“typeVersion”: 4.2,  
“position”: [  
-40,  
-160  
],  
“id”: “c6e7ae9c-54b7-4aeb-896b-1ca930876651”,  
“name”: “HTTP Request”,  
“credentials”: {  
“httpHeaderAuth”: {  
“id”: “{{httpAuthID}}”,  
“name”: “{{Api Key Name}}”  
},  
“{{googleCalendarOAuth}}”: {  
“id”: “{{googleCalendarOAuth Id}}”,  
“name”: “{{Google Calendar Name}}”  
}  
}  
}  
],  
“connections”: {  
“Google Sheets Trigger”: {  
“main”: [  
[  
{  
“node”: “Code”,  
“type”: “main”,  
“index”: 0  
}  
]  
]  
},  
“Code”: {  
“main”: [  
[  
{  
“node”: “HTTP Request”,  
“type”: “main”,  
“index”: 0  
}  
]  
]  
}  
},  
“pinData”: {},  
“meta”: {  
“templateCredsSetupCompleted”: true,  
“instanceId”: “{{instanceID}}”  
}  
}

---

<div class="post-metadata">

**Author:** ![Wouter\_Nigrini](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/wouter_nigrini/32/150261_2.png) [@Wouter\_Nigrini](https://community.n8n.io/u/Wouter_Nigrini)\
**Post date:** [June 30, 2025, 8:09am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/14 "2025-06-30T08:09:40Z")

</div>

Please share your workflow in the code block. We are unable to use the above as this forum changes the formatting

![image](https://europe1.discourse-cdn.com/n8n/original/3X/3/9/398187c73a452d9b55d0fa57ada85cb35cb3a9ea.png)

---

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [June 30, 2025, 8:11am UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/15 "2025-06-30T08:11:37Z")

</div>



---

<div class="post-metadata">

**Author:** ![jabbson](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jabbson/32/87328_2.png) [@jabbson](https://community.n8n.io/u/jabbson)\
**Post date:** [June 30, 2025, 2:48pm UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/16 "2025-06-30T14:48:23Z")

</div>

Try this, worked like a charm for me

---

<div class="post-metadata">

**Author:** ![Patcharee\_API](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/patcharee_api/32/80348_2.png) [@Patcharee\_API](https://community.n8n.io/u/Patcharee_API)\
**Post date:** [July 1, 2025, 12:51pm UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/17 "2025-07-01T12:51:03Z")

</div>

Wow!! it is very nice to use hold on json in HTTP  
I follow you that that is work! 👏

Thank you so much 🙏

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [September 29, 2025, 12:51pm UTC](https://community.n8n.io/t/google-sheet-to-google-calendar/138485/18 "2025-09-29T12:51:31Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.