Save note data to a Google Sheet

[garthwebb]

Context for request: I use this plugin to keep track of the 100's of Google Docs I have to read for work, whether I've read them, a short note about what the doc was about.

Feature request: Allow a Google Sheet ID or URL to be entered in the configuration where note data will be stored. Separate columns for:

• note created
• note updated
• page URL
• note content
• note tags (comma separated)

Any additional columns in the sheet should be ignored by the extension.

This would allow use of Sheets functionality for sorting/filtering, and allow sharing/permissions to be managed via Sheets permissions. Extra columns could be added to further categorize/contextualize the data as the user sees fit (e.g. a "read status" column with data validation of "to read, reading, have read").

Bonus feature request: Customized entry types beyond the text input box. The extension reads the extra columns to look for any columns with data validation. If any exist, for each, the column header and validation options appear in the extension popout as pulldown menus. E.g. a "read status" column that has data validation options "to read, reading, have read" would appear as options in a 'read status' pulldown menu. Choosing an option from this menu would populate the appropriate column in the sheet.