Write a simple Google Sheets Script to Create a Calendar Event from Google Sheets.

  • 状态 完成的
  • 预算 $10 - $30 USD
  • 总竞标 5


I have a Google Form that I am trying to write a script in Google Sheets to automatically populate an AllDayEvent in my Google Calendar. This should be VERY simple. I am not a coder. I found some code online that worked sometimes, but it does NOT work every time. I can supply this code and the form as a basis but here is what I am looking for.

My Google Form has many fields, but I want to create a date using the following:

Date: "NextActionDate" (for an All Day Event)

Text Field 1: "NextAction" to be used as title

Text Field 2: "Customer" be used as meeting location.

This should be triggered by each form submission.



  • 设置你的预算和期限
  • 列出你的提案
  • 获得工资


    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online