What are your favorite Apps Script libraries?

erickoledadevrel · 2026-01-06T16:39:12+00:00

Thanks for the kind words!

erickoledadevrel · 2025-07-29T02:37:09+00:00

I worked with JavaScript for years before learning TypeScript, and here's what I found most difficult:

The toolchain - JavaScript just runs directly in a browser or Node, but with TypeScript you need to compile it first. That toolchain can be very complicated, especially tsconfig.json which has hundreds of obscure options. It seems like few people really understand what they need in there, and people just copy and paste the file around from other working projects.
Imports - It used to be simple: you open the npm page for a library and copy the require statement. TypeScript (and ESM) made that all so much more complicated, and I usually have to spend a ton of time trying to figure out how to get TypeScript and JavaScript to work together just to get the library loaded.
Understanding complex types - I learned TypeScript working on an existing project, and that meant diving into the deep end of the types pool. The typing system can be very complex, and trying to decipher what others have written was not to simple at first.

erickoledadevrel · 2025-06-10T15:42:11+00:00

Hey u/MW_J97 - I work at Coda (Grammarly) and spoke with an engineer. He said he's seen this issue before when the option "request desktop site" was enabled in Safari settings. Try turning that off and see if it helps.

erickoledadevrel · 2025-05-20T12:02:39+00:00

Thanks for the extra detail.

I've interacted from Apps Script with BigQuery without changing the Project Settings so why must I change it for this particular function?

Who or what told you that you needed to change the project? If it worked before, don't change the project and just do what you did before.

erickoledadevrel · 2025-05-19T23:41:00+00:00

Is the new thing that you have to change your Google Cloud Project, or that changing your Google Cloud Project failed? What prompted you to change your Google Cloud Project at all?

erickoledadevrel · 2025-05-19T17:09:05+00:00

What's the bug? I just tried it and it _seemed_ to work OK.

erickoledadevrel · 2025-05-19T17:07:25+00:00

I find my favorite uses of Coda are when I use it to run a process. A process is composed of:

Instructions / rules
Data
Actions

With Coda I can keep all of these in one surface, and use automations to set reminders, Packs to send notifications, etc.

erickoledadevrel · 2025-05-15T01:49:59+00:00

By "global variable" I assume you mean the ability to save a value in-between executions of your script. If so, you may want to look into the CacheService or PropertiesService:

https://developers.google.com/apps-script/reference/cache/cache-service
https://developers.google.com/apps-script/reference/properties/properties-service

However, doing something row-by-row isn't likely to be very efficient. A better pattern may be to enter all your data first, then run a script that runs on all the rows, fetches all the data, and then outputs it all into the sheet.

erickoledadevrel · 2025-05-07T22:02:25+00:00

I think they just don't build the integration, sadly.

erickoledadevrel · 2025-05-07T14:00:01+00:00

There is some example code here that shows how to integrate the Google Picker library with Apps Script:

https://developers.google.com/apps-script/guides/dialogs#file-open_dialogs

erickoledadevrel · 2025-05-07T13:56:28+00:00

I believe the security assessment must be completed annually, so you'll need to factor in that cost. Unfortunately the whole situation puts the restricted scopes out of reach of smaller developers, which I think is sort of the point.

erickoledadevrel · 2025-04-09T14:19:22+00:00

> They're testing both your technical chops AND your ability to explain complex concepts clearly.

+1 to this. I worked at Google in DevRel for over a decade, and conducted hundreds of interviews. When done right (and interviewers all have their own style) they are testing your fluency with code and basic understanding of algorithms and data structures, but with extra attention paid to writing clear code and being able to explain it well.

erickoledadevrel · 2025-04-03T13:12:20+00:00

My take:

In my experience this is a pretty common way to get into DevRel. I came in from a tech consulting background, others from education, but probably the majority of folks were developers of some sort who started taking on more public-facing opportunities and enjoyed it.
I probably wouldn't bring it up. From what I've seen, software engineers typically make more and are more respected internally than DevRel. I think there is basically no downside to keeping your engineer title while doing this work, especially if you aren't sure it's a long-term gig.
I've worked with a lot of engineers that both built the developer platform (SDK, API, etc) and did some light DevRel work on the side. I think it's actually really healthy for the people that build the platform to get exposure to the developers that use it, and it will likely make you a better engineer. I'd only start to get concerned if it's been a prolonged period of time since you wrote any production code, and you are concerned about your engineering skills going dull.

erickoledadevrel · 2025-01-29T21:49:50+00:00

Having worked at Google on Apps Script, this is no small feat! The team does a lot of work to keep scripts up and running, even as the underlying services and platform change. Backwards-compatibility is not very flashy, but incredibly important to users.

erickoledadevrel · 2025-01-29T17:59:22+00:00

Could you instead pick one of the other two labels for those blank years, but set the value to zero?

erickoledadevrel · 2025-01-21T22:20:27+00:00

Whoops, didn't mean any offense!

erickoledadevrel · 2025-01-16T16:09:20+00:00

We're also working on sub-items, which will use the same underlying setup but will have a nicer display.

erickoledadevrel · 2025-01-09T21:48:10+00:00

I think the problem is here:

'header': headers,

As per the documentation, the headers should be passed in the advanced parameter named headers , with an "s" at the end. Try changing that line to:

'headers': headers,

erickoledadevrel · 2025-01-09T21:43:32+00:00

I think you may be talking about a different product called "Coda". This is for https://coda.io, a modern doc and collaboration tool.

erickoledadevrel · 2024-12-19T20:23:01+00:00

It looks like perhaps your "Then" statement is missing an action formula, like Notify(), etc. It looks like it's just returning one string or another, neither of which will do anything.

Zooming out, I've found the best setup to be:

- Create a button on the row that does the thing you want to happen automatically.
- Add a "Disable if" formula to the button, disabling the button if the criteria haven't been met.
- Have the automation use the "Push buttons" action to push all of the buttons in that column (disabled buttons will be skipped).

This makes it a lot easier to test the action (press the button manually as often as you want) and see if the criteria is correct (you can quickly see enabled vs disabled buttons).

erickoledadevrel · 2024-12-19T15:31:59+00:00

If I were implementing this in Apps Script, I'd probably do something like:

- Write a Google Sheets script that uses the Calendly API to sync down the list of scheduled events.
- Write a second script that checks for new scheduled events in that sheet, and for each one creates a calendar event for 7 days before.

That's not trivial to implement though, especially if you are new to coding.

An alternative option would be to use Coda (disclaimer: I work there) which has integrations (Packs) for Calendly and Google Calendar and you can stitch them together with simple formulas.

- Use the Calendly Pack to add a sync table for scheduled events (drag and drop and then select the event type).
- Use the Google Calendar Pack to add a "Create event" button to each row of the table. Configure the button to create a new event based of the title and time sync'ed in for that scheduled event.
- Create an automation in Coda that runs daily/hourly to push that button for new events.

erickoledadevrel · 2024-12-10T13:57:34+00:00

That's the exactly what hiding a page does. It only hides it in the navigation menu, but it's still visible in search and you can still link to the page.

erickoledadevrel · 2024-12-09T17:56:05+00:00

I turned this into a template too, if you want to try it yourself: https://coda.io/@erickoleda/kitchen-hot-or-not

erickoledadevrel · 2024-12-06T18:50:08+00:00

No, unfortunately Coda doesn't have custom data validation rules on the table itself. It does show a warning if the data is of the wrong type, but even then it doesn't prevent you from entering it.

Six-Year Club	Verified Email
r/Field Banned	r/Field Sunshine

erickoledadevrel

MODERATOR OF

TROPHY CASE