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.
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
it's in our todo list. trying to expedit this. will update you once complete
6 днів тому
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.
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?
6 днів тому
@@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.
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?
5 днів тому
@@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?
5 днів тому
@@onescales yes specifically i want to grab the image and upload it as the featured image
@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
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
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!
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
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
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?
@@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.
@@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
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.
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
really appreciate much for your prompt feedback. looking forward to the new updates. thank you.
@@kwwong8633hope to have an update for you
extremely helpful!
Glad it helped!
Thank you for this video, it gave me a good starting for my Apps Script
Your welcome. Good luck in your next steps
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!
it's in our todo list. trying to expedit this. will update you once complete
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.
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.
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
😍😍😍
@@hanzo_process thanks :)
Awesome, thank you!
@@sadathkhan8416 glad you liked it.
ahh finally something workedddd
@@MoAPPS-r3e happy to hear
Nice, Thank you!
@@mscaler4319 your welcome
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
share more in the comments
@onescales could I send you an email?
@onescales hello could I send you an email
@@onescales hello, can I send you an email?
@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
You are genius.
Thanks. Happy you like the topic
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
should be possible by setting a set key in the code and asking for this as another parameter
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!
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?
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
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
try to output error. this will be the best way to beug and figure out@@patricklafontaine4313
Thanks for reply!
It started working suddenly… weird but I ll take it!💁😊
Thanks!
Great work my friend. Is it possible to reduce the delay between making the rest api request and receiveing data.
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?
@@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.
@@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
@@onescalesAlso I was curious if we can add connection like websocket to monitor data instead of refreshing the URL. What is your opinion?
@@RareLykeIN I don’t think so. It is not intended to be used this way.