Well, this is awesome! NoCode API lets you create an API from popular sources, including Google Sheets. Now, I can lookup a user’s email within my Glide table and pull name/image from a completely different spreadsheet. No importranges or helper sheets needed! [Dashboard_-_NoCodeAPI] [Scan_Book_…

How nocode turns out to be a trick to turn people into coders :wink:

Haha this is especially true for me.

Hey @Robert_Petitto , any chance you could put together a tutorial video on using NoCodeAPI?

And good thing I would add because otherwise, you would be an alien! :slight_smile: :ok_hand: :muscle:

Thanks for sharing this! Can you maybe share how the columns are fetching the data? I figured how to add an API thanks to your screenshot- but just can’t figure how to fetch the data. And what exactly should I expect as output?

Check this out: [image] Fetch Column Ask for Help Glide Fetch Column column.sh/fetch is an experimental code column that fetches JSON data from a public API and transforms it with an optional jq query . Example: Fetch a Cat Fact Add column at https://column.sh…

@Robert_Petitto great and nice work So does this help us in row count by anyway? Frankly fetch data in google sheet and only load data as an example if the user clicked or viewed a behavior?

That’s right! I’m using it successfully in one of my apps where I fetch student data “just in time” when completing a form. Now, I don’t need to host the student info in the app.

Hola Robert! Are you using NoCodeAPI or you turned your GS into API to fetch your data students? How big is your GS (rows) to make a comparison with mine regarding performance/speed? Thanks!

I turned my GS into an API using script (cuz it was free). My sheet is 600 rows and takes 3-8 seconds to fetch 4 columns of data.

NoCodeAPI + Fetch ❤️

Project Showcase

Robert_Petitto November 15, 2021, 7:02pm 11

Check this out:

Topic		Replies	Views
🌐 Please help us test: API Column and Webhook action Ask for Help	119	7585	November 18, 2021
Fetch Column Ask for Help custom-code	76	5722	March 8, 2022
Using App Script with a JSON API Community Resources	28	8258	December 24, 2020
↗️ Webhook Action Tutorial Community Resources tutorial	134	8863	December 14, 2023
CRAZY USECASE: Overloading app in a level that created hours delay in writing to Sheet Ask for Help	53	1823	January 17, 2024

NoCodeAPI + Fetch ❤️

Related topics