uneasyguy
uneasyguy
  • Видео 6
  • Просмотров 37 952
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
Просмотров: 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...

Комментарии

  • @jaya-vel
    @jaya-vel 2 месяца назад

    Does GCP will charge us for publishing add ons later?

  • @gothamfury
    @gothamfury 4 месяца назад

    How much does it cost to use Google Cloud Project/service? Is there a usage fee whenever people use the Add-On?

  • @virendrakumar-zp8lv
    @virendrakumar-zp8lv 10 месяцев назад

    Hi, It was nice video, I have little dought , could I dployed the same way Google Slide Add-on in google mark maket place.

  • @milindvedithebunkerboy4914
    @milindvedithebunkerboy4914 10 месяцев назад

    How can we earn from it. Like how to enable monetization

  • @yamamoto9230
    @yamamoto9230 Год назад

    Is anyone outthere to help me on this please

  • @tiechengspreadsheets
    @tiechengspreadsheets Год назад

    Does the add-on need to be reviewed by the marketplace before being published?

    • @onemoreprince
      @onemoreprince 11 месяцев назад

      For Public addons, Yes. For Private add ons, No

  • @jorgecamposlatorre1388
    @jorgecamposlatorre1388 Год назад

    It's an old tutorial, but this helps me so much. Thanks!

  • @MarkBowers-o6p
    @MarkBowers-o6p Год назад

    I've spent hours and hours trying to get the information that you presented. Great presentation and very helpful!!

    • @MarijaPentschev
      @MarijaPentschev Год назад

      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

  • @panchalchirag22
    @panchalchirag22 Год назад

    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!

  • @nicolaslembeye3597
    @nicolaslembeye3597 Год назад

    hey man, are you still around ? I have some question.

  • @jeralgaming853
    @jeralgaming853 Год назад

    Terrible quality

  • @BalaSakthi
    @BalaSakthi 2 года назад

    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...

  • @dasdunetechnologies1695
    @dasdunetechnologies1695 2 года назад

    Nice video, can you make a video but with a Microsoft ecosystem ?

  • @pankzsingh
    @pankzsingh 2 года назад

    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.

    • @parasoulUK
      @parasoulUK 2 года назад

      it's pretty much the same of what this video is about

  • @cobrain4435
    @cobrain4435 2 года назад

    Hi, can a service_account be used to execute the app script from python?

  • @paquinho12
    @paquinho12 2 года назад

    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.

  • @ahtechno.services4520
    @ahtechno.services4520 2 года назад

    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.

  • @wildertriana
    @wildertriana 2 года назад

    Hi friend ! May you help me to publish private one add on that i made. I havent been able too.

  • @avantiya
    @avantiya 2 года назад

    Now the things are changed, please make another video. I want to make a paid add-on then how to do that ?

  • @shadab8798
    @shadab8798 3 года назад

    A lot of things has changed now. And it's so confusing. Now it's called 'Google Workspace Marketplace SDK'

  • @omarchtchareto3701
    @omarchtchareto3701 3 года назад

    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,

  • @anthonyoluu
    @anthonyoluu 3 года назад

    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?

    • @shadab8798
      @shadab8798 3 года назад

      No if it's just for internal use then you don't need to go through the verification process.

  • @marcosernestoalarconhermoz2470
    @marcosernestoalarconhermoz2470 3 года назад

    Can you do it again? now some things have been updated that the video does not see. Thanks

  • @saryingsheng313
    @saryingsheng313 4 года назад

    Thank you so much!

  • @JoeCodeswell
    @JoeCodeswell 4 года назад

    JUST WHAT I NEEDED. THANKS SO MUCH!

  • @joshbottube
    @joshbottube 4 года назад

    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?

  • @aneeshusman1129
    @aneeshusman1129 4 года назад

    Great video do you have git rep for this code. If This code is support 3.6?

  • @killyourself1301
    @killyourself1301 4 года назад

    Great Job! Can you hit me up on Discord? enes#1000

  • @eac10101
    @eac10101 4 года назад

    Thanks so much for this. Google's documentation on how to do this is extremely confusing to follow.

  • @DrSIyer
    @DrSIyer 4 года назад

    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?

    • @cristianidade
      @cristianidade 3 года назад

      You could write an Apps Script to put data on your spreadsheet automatically! ;)

  • @joshbottube
    @joshbottube 4 года назад

    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

  • @nikunjbeladiya8668
    @nikunjbeladiya8668 4 года назад

    Great video, Can you please made video to deploy gmail-on.

  • @jmxt3
    @jmxt3 4 года назад

    Thank you, super clear information. You just rock

  • @overdrivesystem2450
    @overdrivesystem2450 4 года назад

    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.

    • @fisherdude49
      @fisherdude49 4 года назад

      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.

    • @overdrivesystem2450
      @overdrivesystem2450 4 года назад

      @@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.

    • @TheMagic2325
      @TheMagic2325 4 года назад

      ​@@overdrivesystem2450 Hi, I have the same issue. Can you tell sth more about how you did it? I need to fill out he OAuth?

    • @overdrivesystem2450
      @overdrivesystem2450 4 года назад

      @@TheMagic2325 If this is still an issue, email me at karthicksndr@gmail.com. We shall do a zoom call to check this.

    • @DrSIyer
      @DrSIyer 4 года назад

      @@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?

  • @st_luka
    @st_luka 4 года назад

    this is a good guide, but I don't see the code(

  • @pavankulkarni8383
    @pavankulkarni8383 4 года назад

    Hi ,I’m not able to Deploy google docs add on can you please give me any suggestion or idea for that

  • @luisdelgadodelaflorgomez6529
    @luisdelgadodelaflorgomez6529 5 лет назад

    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!

  • @scriptstack3016
    @scriptstack3016 5 лет назад

    great tutorial. I loved it. I wish some more videos on this topic from STARTING TO ENDING.

  • @IBoughtItMyself
    @IBoughtItMyself 5 лет назад

    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.

  • @leoingp
    @leoingp 5 лет назад

    Excellent tutorial, succint and functional. Thank you.

  • @hoalv3918
    @hoalv3918 5 лет назад

    Thanks you so much. But google charge $5 for developer

    • @mikebing1
      @mikebing1 5 лет назад

      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.

    • @traviswarner3934
      @traviswarner3934 4 года назад

      @@mikebing1 what if I want to charge a fee for my addon? What is the best way to do that?

    • @ahmadsobari9129
      @ahmadsobari9129 4 года назад

      @@traviswarner3934 @uneasyguy I ALSO NEED THIS ANSWER