🆕 To-do List Plugin Now Supports the "Format → Convert to Table" Feature
The plugin now works seamlessly with Google Sheets' "Convert to table" format.
You can add a new table row by clicking the ➕ icon.
As a result, an extra blank row is no longer required.
If you prefer not to have a blank row automatically inserted, simply uncheck "Insert task when blank is filled" in the configuration sidebar below.
Getting Started
Get the Template if you haven't done it
Download a copy from:
👉 https://ko-fi.com/s/221bf4dca6
Install the To-do List Plugin
From the Google Workspace Marketplace:
👉 https://workspace.google.com/marketplace/app/todo_list_plugin/1001006504533
Set Up Your Copy
Open your copied spreadsheet and move to where you like
Rename it as you like.
Go to File > Settings and update the Locale to match your region.
Go to Extensions > To-do List Plugin > Plug in to initialize.
📩 Need Help?
Feel free to contact us at spcsoft.solutions@gmail.com for any questions.
Configuration has been enhanced to support user preferences.
One Link Sign-up web application retrieves data based on column letters defined in the configuration. Therefore, all column header names can be customized. Please follow the steps below to set up the potluck sign-up web app:
1. Update Your Sheet Name
Use the Sign-up tab to specify the potluck sign-ups.
Date: Date and time of the potluck (multiple potlucks can be created)
Dish: Name of disk
Sign-up: This field is automatically updated by the web app when people sign up
I will bring: This is a customizable column—delete or add to collect additional information during sign up. All columns will be shown in the sign-up page.
3. Define Potluck Dish Details (Item Tab)
Use the Item tab to provide the potluck dish details.
Item: Must match the Dish name in the Sign-up tab in order to provide the details to sign-up.
Needed: Number of the dishes needed. If blank, only one will be displayed for sign up.
Contact ID: Email address of the potluck host. Host view via the “Set up web app” function will ensure the sign-on user which has Email address defined in this column can access.
Input (optional): Specify what fields are displayed for people to input during sign up. This column must be defined in the configuration. If no input field, the input column in configuration must be blank.
Contact: Name of the potluck host
ID: Email address of the signer (used to access the web app)
Name: Name of the signer (entered during sign-up)
Mobile No.: This is a customizable field—add or rename fields to collect additional information. All columns will be shown in the sign-up page.
Field Definitions:
Sheet names: Names of the sheets (tabs) in your sign-up spreadsheet
Columns: Column letters corresponding to data fields in the Sign-up, Item and Signer tabs
Delimiter in view definition: Delimiter used to separate column headers in different views and the optional input sign-up fields (e.g., ;)
Host view: Columns displayed in the host view (e.g., Date;Item;Name;I will bring;ID;Mobile No.;Contact)
Date;Item;Name;I will bring;Food allegies;Contact)One Link Sign-up web application retrieves data based on column letters defined in the configuration. Therefore, all column header names can be customized. Please follow the steps below to set up the event sign-up web app:
1. Update Your Sheet Name
2. Define Sign-Ups (Sign-up Tab)
Use the Sign-up tab to specify when and how often each post is available.
Required Columns:
Date: Date and time the post is available (multiple entries can be created for the same post)
Post: Name of the post. Details will be defined in the Post tab.
Sign-up: This field is automatically updated by the web app when users sign up
3. Define Available Posts (Post Tab)
Use the Post tab to list the roles or tasks details.
Post: The name of the post (must match the name used in the Sign-up tab)
No. of hours: Duration of the post. Default is 1 hour
No. of slots: Number of available sign-up slots for the post
Contact ID: Email address of the post host. This is used to access the host view via the “Set up web app” function
Contact: Name of the post host
ID: Email address of the signer (used to access the web app)
Name: Name of the signer (entered during sign-up)
Mobile No.: This is a customizable field—add or rename fields to collect additional information. All columns will be shown in the sign-up page.
Field Definitions:
Sheet names: Names of the sheets (tabs) in your sign-up spreadsheet
Columns: Column letters corresponding to data fields in the Post, Sign-up, and Signer tabs
Delimiter in view definition: Delimiter used to separate column headers in different views (e.g., ;)
Host view: Columns displayed in the host view (e.g., Date;Post;Name;ID;Mobile No.;Contact)
Date;Post;Contact)
Date;Post;Name;Contact)
x day intra: Shows sign-ups within the team for the next x days
x day inter: Displays cross-team sign-ups for coordination in the next x days
People without Google accounts can now access the One Link Sign-up.
For new installations, the native script authorization will include the "Send mail as you" permission. If this permission is granted, users will see a sign-in page below in the web app where they can enter their email address to receive a password-free access link.
Thank you to Lisa who contacted developer on the exception.
From Google execution log, the setup function submitted the createTemplateForm twice. The exception came from the 2nd submission.
