- Видео 6
- Просмотров 37 952
uneasyguy
Добавлен 9 ноя 2007
Tomcam Apps Script Tutorial Potential Changes
u/tomcam on Reddit posted the following tutorial appscripting.com/tutorials/apps-script-sidebar-tutorial.html
and asked for people to take a look and suggest any changes.
This video is in response to that post, you can view the revised code here: script.google.com/d/1JftNWgA-eB6oA58EU57ELhhVKMmXLQ16aN0L0wbTkWOqK5WXOjCDB0Yl/edit?newcopy=true
and asked for people to take a look and suggest any changes.
This video is in response to that post, you can view the revised code here: script.google.com/d/1JftNWgA-eB6oA58EU57ELhhVKMmXLQ16aN0L0wbTkWOqK5WXOjCDB0Yl/edit?newcopy=true
Просмотров: 95
Видео
How to Speed Up Your Python Code with Asyncio
Просмотров 1965 лет назад
Quick run through of converting a synchronous code to an asynchronous code and viewing performance gains. Using python 3.7
Flask Restful API - Google VM - Forever Monitor- Google Sheets p.2
Просмотров 1145 лет назад
I apologize for having the bottom right window covering the ssh terminal. Lesson learned and will avoid in the future SERVER VERSION OF APP.PY: gist.github.com/uneasyguy/c9d4ae55e08fa2984fcd8edd95597393 SERVER VERSION OF TESTING.PY: gist.github.com/uneasyguy/f4d8511b3cced004cd69535dafb070b9 SERVER COMMMANDS: sudo apt-get update sudo apt-get upgrade -y sudo apt install python3-pip -y sudo -H pip...
Flask Restful API - Google VM - Forever Monitor- Google Sheets p.1
Просмотров 685 лет назад
Part 1 of 2 - Creating restful API with Python and Flask and running locally to return cryptocurrency price data from Binance. app.py - gist.github.com/uneasyguy/a4741a00487072b6a45de10b6efe0903 testing.py - gist.github.com/uneasyguy/997356dcfebec53c4bb1e99dd5b15edb
Deploy Google Sheet Add-on
Просмотров 37 тыс.5 лет назад
Quick video to turn a google apps script into an unlisted google add-on. To create a listed add-on, the steps are almost identical. resizeimage.net/ - link to a basic image resizer if needed
Update Google Sheets/Apps Script via Python from EC-2 Server
Просмотров 9785 лет назад
update time function - gist.github.com/uneasyguy/9470eda20e0b8df524ef48ade6d252c6 python script to execute apps script - gist.github.com/uneasyguy/9edbba65cac4f1fd9d5b28c3f28e5297 python required packages command - pip3 install upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib ec2 ssh format- sudo ssh -i "path to .pem" "username"@"ip" server update commands- sudo apt-ge...
Does GCP will charge us for publishing add ons later?
How much does it cost to use Google Cloud Project/service? Is there a usage fee whenever people use the Add-On?
Hi, It was nice video, I have little dought , could I dployed the same way Google Slide Add-on in google mark maket place.
How can we earn from it. Like how to enable monetization
Is anyone outthere to help me on this please
Does the add-on need to be reviewed by the marketplace before being published?
For Public addons, Yes. For Private add ons, No
It's an old tutorial, but this helps me so much. Thanks!
I've spent hours and hours trying to get the information that you presented. Great presentation and very helpful!!
Hey there, everything worked until Minute 15:08 --> As the Editor has changed and there's no: Publish --> Deploy as Add-On Menu anymore. Do you have any idea where to find the menu instead? I've searched the whole editor but can't find anything
This will help me a lot. I have made a code for last month and I don't know anything about GCP. Again, Thank you very much!
hey man, are you still around ? I have some question.
Terrible quality
Nice, Thanks for your tutorial. I tried to upload my own add on for google sheet but Google says "Needs verfication". I want to share my add on with others is it possible to do deploy without verfication? Thanks...
Nice video, can you make a video but with a Microsoft ecosystem ?
Hi! Can you please make a detailed video on how to create and deploy a Google Sheet add-ons on Google Workspace Marketplace? This will be helpful for many people.
it's pretty much the same of what this video is about
Hi, can a service_account be used to execute the app script from python?
Thank you a lot!! This was the only tutorial on how to deploy a script and publish as add on. Even though today is very different these steps helped me to understand how to publish my app.
can you mention the differences ?
Very good video. Thanks for making such a video. To share Unlisted add-on, we have to share via link. When we share via link, can they access the code in Apps script ? Is there any Quota limit for unlisted app ? I mean how many user can install and how many times the app can be called.
Hi friend ! May you help me to publish private one add on that i made. I havent been able too.
Now the things are changed, please make another video. I want to make a paid add-on then how to do that ?
A lot of things has changed now. And it's so confusing. Now it's called 'Google Workspace Marketplace SDK'
Hi dear, I hope you are well, I need to make a project like this: ruclips.net/video/P2YIFB-sSPs/видео.html as a brief for what I need, I want to make password protection for google sheets and I want to use it in my all sheets. please tell me if you can do it or not? Regards,
Thanks for sharing your video. I have a set of functions that I wrote via "script editor" and I would like to be able to call those functions across all my Google Sheet (for internal use only). Do I have to go through all these steps to publish them as Add-on or do I have any other option?
No if it's just for internal use then you don't need to go through the verification process.
Can you do it again? now some things have been updated that the video does not see. Thanks
Thank you so much!
JUST WHAT I NEEDED. THANKS SO MUCH!
I was able to deploy and subscribe to my add-on thanks to this tutorial. That said, I added the onInstall function at the beginning of my normally functioning scripts but they are not functioning. Are there any other script differences I need to consider? If so, is there a place where I can find documentation on the issue?
Great video do you have git rep for this code. If This code is support 3.6?
Great Job! Can you hit me up on Discord? enes#1000
Thanks so much for this. Google's documentation on how to do this is extremely confusing to follow.
very veeerrrrrry confusing
Hi. Thank you for the video! Very informative indeed. I have written a Google sheets apps script that requires some data to be there in the first two columns of a google sheet for the user to correctly run the function in the script. Can I deploy such an apps script (having a requirement of some data being there) to an add-on?
You could write an Apps Script to put data on your spreadsheet automatically! ;)
AWESOME! I carefully went through this video and used screenshots it to make a step by step Google Sheet instruction manual: docs.google.com/spreadsheets/d/1gUowDRNfzMy86HM5o9tcjsHrTBFtX4pWKhRAWvoAPU0/edit#gid=0
Great video, Can you please made video to deploy gmail-on.
Thank you, super clear information. You just rock
I have saved the GSuite Marketplace SDK configurations. When I go to Publish --> Deploy as sheet add-on, I don't see the screen that we expect. Instead it gives me instructions to deploy add-on. Please help me resolve this issue. Thanks.
I have the same issue. Let me know if you resolve it. The next step I followed was going to 'Publish' in the G Suite Marketplace SDK API, filling it out, and pressing publish which has sent me through the OAUTH 2.0 process which I don't fully understand. It might have something to do with Chrome Web Store switching to the G Suite Marketplace.
@@fisherdude49 You have got the right option. Click on the 'Publish' option and follow his instruction from "Publish ==> Deploy as sheets add-on part", which is so simple. I did get some issues. But then I have created a new project from scratch and it works super cool now.
@@overdrivesystem2450 Hi, I have the same issue. Can you tell sth more about how you did it? I need to fill out he OAuth?
@@TheMagic2325 If this is still an issue, email me at karthicksndr@gmail.com. We shall do a zoom call to check this.
@@overdrivesystem2450 . Hi. Thank you for the video! Very informative indeed. I have written a Google sheets apps script that requires some data to be there in the first two columns of a google sheet for the user to correctly run the function in the script. Can I deploy such an apps script (i.e. having a requirement of some existing data being there) to an add-on?
this is a good guide, but I don't see the code(
Hi ,I’m not able to Deploy google docs add on can you please give me any suggestion or idea for that
Hi! Thanks for this video! I followed thru with easy. I've got a question tho.. My organization has a very old free G Suite account (those free with up to 50 users). Is it possible to deploy addons with this type of account? Thanks!
great tutorial. I loved it. I wish some more videos on this topic from STARTING TO ENDING.
Me too. This videos are so important.
Thanks, Uneasyguy, wish I could give it more than one upvote! On the one hand I don't agree with everything you did, but on the other I definitely learned from everything you showed and can see how to use it all in later projects. Tutorial is at appscripting.com/tutorials/apps-script-sidebar-tutorial.html and will definitely update it to reflect some of this black belt material you offered! Grateful for your guidance.
Excellent tutorial, succint and functional. Thank you.
Thanks you so much. But google charge $5 for developer
Yes, there is a one time $5 fee. As soon as you pay it, you'll be approved to post up to 20 sheets add-ons. It's a pain, but keeps out the rift raft I suppose.
@@mikebing1 what if I want to charge a fee for my addon? What is the best way to do that?
@@traviswarner3934 @uneasyguy I ALSO NEED THIS ANSWER