Making Google Sheet Into a Public REST API

[@pedroalonso1048]

Amazing! Will this code by any chance be updated to allow for filters or delete other methods like delete or patch?

[@onescales]

Yes you can modify the code in any way fit. Either ask a developer or chatgpt or other ai and you could add to it

[@chrisder1814]

Hello, I made a product catalog on Google sheet, and I would like to sell my products on multiple marketplaces, I would like my stock to be synchronized on all marketplaces For this, would I have to use the APIs?

[@onescales]

It is doable with an excel sheet but much more efficient via your ecommerce platform. For example if you have shopify you just setup your invesntory there and your marketplaces integrations will handle everything. and to answer your apis question, yes you would need apis to integrate with the marketplaces.

[@kwwong8633]

really thanks to this simple yet efficient way to insert data. is that a way I could manage more than one column? especially for writing. thanks in advance.

[@onescales]

Your welcome. Yes it is possible to modify the script fairly easily to support more than one column. It’s in our todo task list to improve this tutorial but currently not in priority. Sorry about that. Once I get to it I can update you. Otherwise if you are brave you can try chatgpt to ask it to improve the code to have 2 columns and you probably can get it to work

[@kwwong8633]

really appreciate much for your prompt feedback. looking forward to the new updates. thank you.

[@onescales]

@@kwwong8633hope to have an update for you

[@amarildocs]

Would it be possible to insert more values ​​in more than one column? If you could make a video lesson updating this one, then that would be great!

[@onescales]

it's in our todo list. trying to expedit this. will update you once complete

[@user-le2zv6go3v]

extremely helpful!

[@onescales]

Glad it helped!

[@AstraSoft254]

Can you make a Video showing how i can make REST Api with it

[@onescales]

this sheet is a rest api. can you explain more what you need?

[@JobinAugustine]

Thank you for this video, it gave me a good starting for my Apps Script

[@onescales]

Your welcome. Good luck in your next steps

Using this video I was able to push my sheet (a row w/a "title" and "description" column ) to a blog post! Thanks! Any resources or help on how to get images to post as a featured image? I added a new column for "external image URL" but not having luck.

[@onescales]

Can you explain more? You want to add another column for image url but what data do you want? The actual image or just a text url?

@@onescales Sure, I added another column G that will take an input of an external image's URL. any random image from google. I want that image to be the post's featured image.

[@onescales]

is your question? how to add an additional column to input this data? how to grab an image? can you share more and give an example?

​@@onescales I have the empty column in google sheets. The input for the image will be a URL (for example .jpg). I also have a column for Post Title and Post content which uploads properly, but image is not being uploaded into the post's featured image. Would it be possible to get in touch with you directly so I can share the sheet and script?

@@onescales yes specifically i want to grab the image and upload it as the featured image

[@haha7836hahah]

I want to add some authorization to the api. Is there a way to store environment variables or do i need to put the token in the code for performing comparisons

[@onescales]

should be possible by setting a set key in the code and asking for this as another parameter

[@chrisder1814]

I still can't understand, could you give me some sites, URLs that I could read to understand what appscript would allow me to do

[@onescales]

simply put, google sheets is a spreadsheet. apps scripts allow you to add coding to make it do more things. this video uses code (aka appscript) to make it easy to import automatically data from other places.

[@chrisder1814]

@onescales Ok what I meant is that I'm having trouble following correctly, could you recommend some websites to read so that I can better understand the basics and then what I Can do with appscript compare to other languages

[@onescales]

Probably the best is to use chatgpt to explain more detail. Other alternative is to check in google or KZbin for tutorials for beginners

[@chrisder1814]

@@onescales Yes, that's obviously what I did, but you don't know?

[@onescales]

@@chrisder1814 not sure what you’re looking for. Can you share more detail?

[@김현성-v7t4p]

You are genius.

[@onescales]

Thanks. Happy you like the topic

[@sadathkhan8416]

Awesome, thank you!

[@onescales]

@@sadathkhan8416 glad you liked it.

[@patricklafontaine4313]

Hi! thanks for this, its working fine but I have an issue with a 3rd party app that only sent post request. It looks like the script only get params from the url so does not catch params from json post request... Do you have any ideas on how to do it? Maybe a line to add to catch those json params? Thanks!

[@onescales]

Hi. I'm pretty sure you can make it work by changing the doGET function to doPOST. Do you have the same exact requirements as in the video?

[@patricklafontaine4313]

Yes, I was able to make it works just after my previous comment, it was exactly that, I used DoPost() and adjust my request with my params and its working. The only little issue is that it wont trigger change event trigger, so I need to use more code to do what I want inside the DoPost(). Pretty cool feature no matter this! :) thanks again!@@onescales

[@patricklafontaine4313]

actually, I still have an issue or 2... its working but wont do some code. I tried the same code on my change event and its working well, but from DoPost() it wont execute those lines: var today = new Date(); var year = today.getFullYear(); if(sheet.getRange(3,19).getValue()==0 || sheet.getRange(3,19).getValue()==""){ sheet.getRange(3,19).setValue(1); sheet.getRange(3,20).setValue(year);} dont know why, and the other thing is that it seems not to trigger zapier event neither. Pretty weird, I try to make it working but not sure on what to do with my content since it wont trigger anything. I ll try to make another web request from DoPost() to forward my data but I must make the calculation works before.@@onescales

[@onescales]

try to output error. this will be the best way to beug and figure out@@patricklafontaine4313

[@patricklafontaine4313]

Thanks for reply! It started working suddenly… weird but I ll take it!💁😊 Thanks!

[@mscaler4319]

Nice, Thank you!

[@onescales]

@@mscaler4319 your welcome

[@MoAPPS-r3e]

ahh finally something workedddd

[@onescales]

@@MoAPPS-r3e happy to hear

[@chrisder1814]

hello I had some ideas for using Google sheet and apps in general and I wanted to get your opinion since you know it much better than me

[@onescales]

share more in the comments

[@chrisder1814]

@onescales could I send you an email?

[@chrisder1814]

@onescales hello could I send you an email

[@chrisder1814]

@@onescales hello, can I send you an email?

[@chrisder1814]

​@onescales I would like to retrieve the history of my sales made on Amazon in a Google sheet I think that to use the Amazon API then you have to code in appscript? but I don't know anything about it, do you know the API connector extension? could I send you an email

[@hanzo_process]

😍😍😍

[@onescales]

@@hanzo_process thanks :)

[@RareLykeIN]

Great work my friend. Is it possible to reduce the delay between making the rest api request and receiveing data.

[@onescales]

Thanks! Do you mean it takes time to get the data. For example -5 seconds? If so, depend on the size of your sheet but probably not much to optimize. Can you share more?

[@RareLykeIN]

@@onescales Yes exactly that 5 seconds delay time, can it be reduced, like if we are to use it for some real time inventory management system or maybe controlling an IOT device ON/OFF state.

[@onescales]

@@RareLykeIN not really. This free solution is not intended to be real time or used for time dependent tasks. For those you would want a server, database and code

[@RareLykeIN]

​@@onescalesAlso I was curious if we can add connection like websocket to monitor data instead of refreshing the URL. What is your opinion?

[@onescales]

@@RareLykeIN I don’t think so. It is not intended to be used this way.