Make.com Google Sheet (Dynamic Column)

The goal is using Make.com to adopt Dynamic Column for Google Sheet

List of solution:
1. 100% Google Appscript
2. Google Appscript + Make.com
3. Google Appscript + Make.com + Edge Functions

1. Google Appscript, when i explore google appscript limitation there is a runtime limitation which will be explode when there is a multiple functions thru different google workspace, we are just using "Personal Workspace"

2. Google Appscript + Make.com, with this combination the modules within make.com will have a very complex design it will consume up to 6 modules, without javascript function of "Enterprise Plan" of course.

3. Google Appscript + Make.com + Edge Functions, with this the solution for Google Appscript Limitation for runtime will be solve because we will just use the runtime to throw the data to Edge Functions, there is no process included so the ms consumption will be 99% decrease, additionally Make.com only offer the javascript functionality inside "Enterprise Plan" which will lead our company into new expenses, with that i planned to use Cloudflare Workers to process our data. Using secured webhooks we can manage the process from Google Appscript to Edge Functions to Make.com back to Google Workspace.

Problem Solved:
- Google Appscript Runtime
- Make.com Javascript force to use "Enterprise Plan"
- Make.com Complexity
- Google Workspace Authentication/Authorization for "Personal Accounts" use Make.com to assess that

Goal:
- To have dynamic column inside google sheet

Been thinking about this for 3mos, and there was like a wind and told me hey use old approach middleware.

With that wind i think about webdev middleware, where the data from database he handle and process the data to front end to display and viola magic happens.

Sometimes the solution aren't no-code, but accept the tradition that not everything should be easy.