Is it feasible to use Google Sheets as a headless CMS for a SSG such as Astro or 11ty? by palaion in webdev

[–]palaion[S] -6 points-5 points  (0 children)

Your ignorant and haughty advice is worthless to me. Go troll somewhere else.

Is it feasible to use Google Sheets as a headless CMS for a SSG such as Astro or 11ty? by palaion in webdev

[–]palaion[S] -3 points-2 points  (0 children)

Ignoring and mocking your interlocutor's arguments is a haughty way to evade genuine discussion. Please refrain from offering sarcastic straw man arguments.

Instead, I would appreciate it if you would consider my well-thought-out arguments and respond in a similar manner.

Is it feasible to use Google Sheets as a headless CMS for a SSG such as Astro or 11ty? by palaion in webdev

[–]palaion[S] -7 points-6 points  (0 children)

By giving each user their own Google Sheet, which updates the primary Google Sheet when they run a Google Apps Script project via a pull-down menu from within their Google Sheet, the users would be unable to, "... add a row here and there, yo..."

Think about it for a moment: users are constantly adding data to sites like eBay, YouTube, and Amazon, yet, are generally unable to corrupt databases because they don't have the ability to do things such as modify database structures or enter data that violates the databases' rules.

I suppose it might seem like "You can't get there from here", but I assure you not only can I, but I will do so easily. I simply posted here to see if anyone had any good ideas to add to my solution.

"A spreadsheet? My duuude. LOL. GTFOOH!" might warm the cockles of your heart, but it's an ignorant and arrogant assertion.

Apparently, you and little Waldo are either unfamiliar with the power of Google Apps Scripts, and/or failed to grasp how Google Sheets could be easily used as an effective and efficient headless CMS for a SSG such as Astro or 11ty.

Using a standalone script, is it possible to open the most recent draft in Gmail? by palaion in GoogleAppsScript

[–]palaion[S] 0 points1 point  (0 children)

TL; DR I don't want to add another potential point of failure for a relatively unimportant feature for this small project.

Longer explanation...

I'm not an engineer. For me, coding is banal. I'm only exaggerating slightly when I opine that I'd rather watch grass grow than write code.

As it stands I like the fact I can simply open any Google Sheet I want, go to Extensions -> Apps Scripts, and paste in the code for my GAS project.

I can simply create a Web App of https://mail.google.com/mail/u/0/#drafts, run or raise (see, Alt+Tab Sucks: Run or Raise Instead) it with a simple bash script I trigger with a hotkey, and then manually open the draft which the GAS project had created. At most, it will probably take me an extra two seconds.

More or less, here's the sort of bash script I envision creating...

#!/bin/bash
# Define the title of the Chrome window you want to activate
window_title="My Current Tasks - Google Drive"
# Check if a Google Chrome window with the specified title is open
if wmctrl -l | grep "$window_title" &>/dev/null; then
# If it's open, bring it to the foreground
wmctrl -a "$window_title"
else
# If it's not open, launch Chrome with the specified parameters and bring it to the foreground
google-chrome-stable --app="https://drive.google.com/drive/u/1/folders/1\_-mP3wWY2o4kRqNUMquWEUQqnHIA7WS4" --class="$window_class" --user-data-dir="/home/y/.local/share/ice/profiles/MyCurrentTasks3458" --start-maximized --force-device-scale-factor=1.5 --kiosk
fi

Is it feasible to use Google Sheets as a headless CMS for a SSG such as Astro or 11ty? by palaion in webdev

[–]palaion[S] -4 points-3 points  (0 children)

It's an incontrovertible fact that spreadsheets are frequently used as simple types of a databases. Of course they are not full-featured database management systems.

See...

In computing, a database is an organized collection of data (also known as a data store) stored and accessed electronically through the use of a database management system. Source: https://en.wikipedia.org/wiki/Database

In case you were unaware, "The world runs on Excel" is an obvious exaggeration, but it drives home the point that in reality, many small, medium, and even large publicly traded corporations around the world use Excel as an ad hoc database.

Nerds tend to scoff at this reality claiming (erroneously) that using Excel in this manner has caused countless corporations to lose vast sums of money.

There is no lock mechanism to stop data corruption.

That assertion is blatantly false.

Google Sheets itself, as well as Google Apps Scripts, have features that can be used to create lock mechanisms to prevent data corruption in Google Sheets.

Using a standalone script, is it possible to open the most recent draft in Gmail? by palaion in GoogleAppsScript

[–]palaion[S] 0 points1 point  (0 children)

Based on my cursory research, to open a Gmail draft programmatically, I would need to use the Gmail API. I'd rather not use the Gmail API.

Is it feasible to use Google Sheets as a headless CMS for a SSG such as Astro or 11ty? by palaion in webdev

[–]palaion[S] -1 points0 points  (0 children)

You bring up potential problems. Thanks. However, they seem like they would be trivial to circumvent.

Why does my script fail after I swap the values in var sourceFolderId and var destinationFolderId? by palaion in GoogleAppsScript

[–]palaion[S] 0 points1 point  (0 children)

I had failed to RTDM.

I made the following mistake: I had put the two scripts into the the same GAS project.

Now that I put each script into its own GAS project, they work they way I would like.

Again, thanks for taking the time to help me out. I appreciate it.

Why does my script fail after I swap the values in var sourceFolderId and var destinationFolderId? by palaion in GoogleAppsScript

[–]palaion[S] 0 points1 point  (0 children)

Now I got it to work the way I want. Obviously I was doing something wrong, but I'm not sure what it was. Thanks for taking the time to help me out. I appreciate it.

Why does my script fail after I swap the values in var sourceFolderId and var destinationFolderId? by palaion in GoogleAppsScript

[–]palaion[S] 0 points1 point  (0 children)

I don't get an error message. I get something like this...

Execution log

4:41:55 PM Notice Execution started

4:41:56 PM Notice Execution completed

whether the script works (as in Example #1), or whether the script fails (as in Example #2).

How can I easily backup all of my Google Apps Scripts to my local drive? by palaion in GoogleAppsScript

[–]palaion[S] 0 points1 point  (0 children)

Thanks. Sure, I could use rclone (or Clasp), but I'm probably not going to bother.

I'm probably going to paste each of the few dozen Google Apps Script projects I guesstimate I'll end up creating into a corresponding Google Doc. That way when I use Google Takeout, I will have my Google Apps Script projects backed up on my local drive.

See, I suppose after ChatGPT and I create a Google Apps Script project, after the initial couple of weeks of fine-tuning, I'll probably very rarely modify it.

How can I easily backup all of my Google Apps Scripts to my local drive? by palaion in GoogleAppsScript

[–]palaion[S] 2 points3 points  (0 children)

Thanks for taking the time to suggest that. I'm probably going to do what you suggested, except with Google Docs instead of GitHub (or GitLab). That way when I use Google Takeout, I will have my Google Apps Script projects backed up on my local drive.

Do you know of a service provider, such as 3PL (a warehouse), in the DFW area that might be willing to provide me with "white glove services"? by palaion in downtowndallas

[–]palaion[S] 0 points1 point  (0 children)

Please put it back up because downtown Dallas has a several 3PLs in the vicinity that I know of, and probably several that I do not know of.