Пікірлер

• 
  @MilošPelikán-q3sКүн бұрын

  for facebook?

• 
  @BetterSheets23 сағат бұрын

  Fb makes it hard to scrape anything.

• 
  @riccardoluise8630Күн бұрын

  0:00 Introduction 0:40 API Overview and Benefits 1:01 Project Overview 2:00 Setting Up App Script 5:01 Testing the API 6:39 Debugging 7:34 Redeploying the Web App 8:43 Fetching Data with doGet 9:48 Using ImportData Function 10:30 Creating and Deploying an Online Form 12:55 Summary and Conclusion

• 
  @momorama88322 күн бұрын

  I knew that but when I actually need to use it I forgot my own namd

• 
  @BetterSheets23 сағат бұрын

  Name?

• 
  @CansunCoskun4 күн бұрын

  Absolute madlad

• 
  @luiscorado28684 күн бұрын

  Fantastic, awesome job!!!

• 
  @nabilchoironnaim52484 күн бұрын

  Where can I get the proggress plant? Please anyone told me

• 
  @BetterSheets3 күн бұрын

  You can use any images you want.

• 
  @MohammadAli-nn4ov5 күн бұрын

  I usually use Ctrl E.

• 
  @BetterSheets5 күн бұрын

  Sweeet

• 
  @MISComputerNET7 күн бұрын

  Great idea! Thanks for the lovely tutorial. Could you please make a video explaining how to use onEdit multiple times in apps script? In my trials, I could manage to make two onEdits work. When I add a third one, first two works fine but third doesn't. Thanks in advance.

• 
  @BetterSheets6 күн бұрын

  Cannot use onEdit() more than 1 time. Need to add inside one onEdit all the things you want to do. Use IF() {} to gatekeep.

• 
  @MISComputerNET6 күн бұрын

  @@BetterSheets This is exactly what I mean. I made a new onEdit.gs file and placed multiple onEdit under this new gs file with if statements. I will try to send an email with the code later.

• 
  @BetterSheets5 күн бұрын

  @@MISComputerNET you only need one on Edit() and in fact if you have multiple they won't work. as you found out. just need function onEdit(e) { and then place anything you want inside here} Perhaps, maybe.. quite possibly the if statements are overriding each other or not allowing you to do the exact thing you want. There is a bit of an art to the if() statements

• 
  @MehreenSohail-c6w7 күн бұрын

  I tried it, did not work

• 
  @BetterSheets6 күн бұрын

  Did you get an error?

• 
  @carlossanteliz52937 күн бұрын

  Great. Thank you and greetings from Nicaragua.

• 
  @BetterSheets6 күн бұрын

  Hellooooo!

• 
  @carlossanteliz52936 күн бұрын

  @@BetterSheets Hi there : )

• 
  @mosheyuval3508 күн бұрын

  This is too good to have so little likes well done!

• 
  @BetterSheets6 күн бұрын

  Maybe one day.

• 
  @dominiqueramirez71908 күн бұрын

  This was amazing!! May I ask if I can add an IF formula to the FILTER formula. Say for example on my google form its "Yes, see you there." and "Sorry, can't make it.". And I want it to fill up as "CONFIRMED" for "Yes, see you there.", and "DECLINED" for "Sorry, can't make it.". What formula should I use?

• 
  @ronaldjohnson_ita8 күн бұрын

  Great video and way of thinking. I was wondering, do you have a spreadsheet design to remove or add users to protected ranges, list all protected ranges, and modify protected ranges? Sometimes it is tedious to always go in and remove or modify protected cells. I’m thinking if there was a separate “Protected Ranges” tab it would be easier to manage. Or if a team member leaves, you can transfer the email to another person rather requesting access.

• 
  @maxyusupov95089 күн бұрын

  can you tell about how to call your addon for special sheet that you will sell in your website, so sheet which user will buy addon will be called?

• 
  @BetterSheets9 күн бұрын

  Can you please explain? Addon special sheet?

• 
  @tortaperformance10 күн бұрын

  That's great! Do you know a solution that works for Vimeo URLs too? Thanks!

• 
  @BetterSheets9 күн бұрын

  Should be similar. Inspect element. Look for xpath and use Importxml.

• 
  @AndrewPetzold10 күн бұрын

  OKAY YOUR SPREADSHEET IS AT 1 MILLION CHECKS

• 
  @BetterSheets9 күн бұрын

  Thank you

• 
  @tig4rx11 күн бұрын

  Does each post/get request counts as one Google Sheets API request? And is possible to use Bearer token to prevent anyone with the link to just be able to manipulate the data?

• 
  @BetterSheets11 күн бұрын

  You can set up a token system yes.

• 
  @tig4rx10 күн бұрын

  @@BetterSheets Awesome, do you know if each post/get request counts as one Google Sheets API request? Or they aren't sharing the quota?

• 
  @BetterSheets9 күн бұрын

  @@tig4rx don't think they are sharing the quota.

• 
  @EndroPora11 күн бұрын

  how does the script reconnect the google form with the spreadsheet on the original sheet

• 
  @BetterSheets11 күн бұрын

  Sorry what do you mean by reconnect?

• 
  @hadigusty12 күн бұрын

  So, if the name was separate by a space, just put " " ?

• 
  @BetterSheets12 күн бұрын

  Yep!

• 
  @ttone233013 күн бұрын

  Thank you for the Basics it really helped me to get started.

• 
  @BetterSheets12 күн бұрын

  Keep going!

• 
  @user-ty7tm9ow7u13 күн бұрын

  Hi there, do you teach this? I need this for work but I need help on how to automate for reporting big data.

• 
  @BetterSheets13 күн бұрын

  Full courses at Bettersheets.co if it doesnt have something you need you can always ask me anything.

• 
  @MISComputerNET13 күн бұрын

  Hi, Thanks for the great video. I am a newbie in this coding stuff and sometimes me and my computer stare at each other unmeaningfully 😊. However, with your video, I think I will be more confident about these errors and messages

• 
  @BetterSheets13 күн бұрын

  Send me any error messages you stare at for too long

• 
  @MISComputerNET13 күн бұрын

  @@BetterSheets thanks I will do that. I think the main thing is to comprehend the core logic in a coding language. Afterward, although the details are not provided as you mentioned in your video, at least you can have a rough idea where to look at and how you should continue.

• 
  @achmdalfy715714 күн бұрын

  How join ?

• 
  @BetterSheets13 күн бұрын

  Join for full access at bettersheets.co

• 
  @luke.warm.tea6915 күн бұрын

  very helpful

• 
  @BetterSheets14 күн бұрын

  Awesome to hear its helpful

• 
  @pinkcohort15 күн бұрын

  Thanks for the video! I have a cell where I put a numerical "goal" and beside it a cell that shows the "actual" total of checkmarks for each column. I want to make a progression of images based on the percentage achieved of the "goal" cell. What formula should I use? Also, please put the formula for Apps Script if you're familiar with using that. Thanks!

• 
  @xXx-un3ie15 күн бұрын

  Or just either ctrl+shift+c & ctrl+v OR ctrl+c & ctrl+shift+v

• 
  @BetterSheets13 күн бұрын

  Works

• 
  @MISComputerNET15 күн бұрын

  Excellent tip, thanks for sharing! You have just got another subscriber

• 
  @BetterSheets13 күн бұрын

  Looking forward to more comments!

• 
  @1lllllllll116 күн бұрын

  A button without a label is not very good design. I wish sheets had a simple onclick event handler to run a function, without having to draw a silly graphic.

• 
  @BetterSheets16 күн бұрын

  Can use onEdit() and some if statements

• 
  @1lllllllll116 күн бұрын

  This is great for tagging, that’s exactly what airtable solved nicely in their UI, and I’m very happy you covered this topic.

• 
  @BetterSheets16 күн бұрын

  And dropdown chips, I think, were google's answer to airtable.

• 
  @1lllllllll116 күн бұрын

  Thank you so much for the curly brackets tip, that was awesome!

• 
  @BetterSheets16 күн бұрын

  Nice. Glad its helpful!

• 
  @alfredoramirez833617 күн бұрын

  WOOOW your genius! excellent tutorial... may i invite you a cofee on patreon or anything similar? excellent tutorial!

• 
  @BetterSheets16 күн бұрын

  Become a member of better sheets. More awaits inside!

• 
  @annequeen190518 күн бұрын

  Can you share your template with me? Would love to test it out.

• 
  @unsequencedrecords528518 күн бұрын

  Can you share this template?

• 
  @Gainmackain120 күн бұрын

  You can update your current deployment to the latest version. No need to redeploy every time.

• 
  @ElleRingArt20 күн бұрын

  Can we do this by taking data from another sheet?

• 
  @BetterSheets20 күн бұрын

  Sure!

• 
  @aleksandrpletnev667223 күн бұрын

  Any videos / links on how to implement analytics to properly collect engagement, external links, etc? In Google Console i was able to add my GA number to the project but it collects only visitors of my Workspace Marketplace page.

• 
  @Kidsanimation98423 күн бұрын

  Hey can you please highlight video of website scraping using good sheets?

• 
  @BetterSheets22 күн бұрын

  Look for any videos with or about importxml Bettersheets.co/formulas/importxml

• 
  @godschild726724 күн бұрын

  I already have #ERROR!, I need to remove it from all the cells at once, If I click on one cell and remove +1 then, this error goes away, So I want to do that for all the cells at once.

• 
  @BetterSheets23 күн бұрын

  Try to find and replace all

• 
  @NicholasBugeja24 күн бұрын

  For some reason it is not working for me... I put the app script correctly and API correctly, very easy to do, but after putting the function =ai(A1) it just returns with an error, I only have ChatGPT Free Plan, do I need to upgrade it? Thank you!

• 
  @BetterSheets23 күн бұрын

  You need api access. Not just chatgpt.

• 
  @hoducthang991325 күн бұрын

  scam

• 
  @BetterSheets25 күн бұрын

  Hmm.. interesting way to put it.

• 
  @Mike_032527 күн бұрын

  After carefully reviewing your video, one thing I realized. You intend to mess up things because your intention is clearly not to teach at all but more on views so as others will rewatch your videos many times, and not really to be educational at all. Bad tactic. You deserve my thumbs down button.

• 
  @BetterSheets26 күн бұрын

  Thanks for the review.

• 
  @freshpotion27 күн бұрын

  Very fun. Love seeing these ideas from you

• 
  @BetterSheets26 күн бұрын

  Enjoy more!

• 
  @GehirnGoldmine28 күн бұрын

  Great! To teach, while you are developing, is of great use for me. 🙂

• 
  @BetterSheets28 күн бұрын

  Sweet!

• 
  @klutzpc15229 күн бұрын

  How to do the part in "range"?

• 
  @BetterSheets29 күн бұрын

  You can use row,column notation or A1 Notation.

• 
  @FANTHEORYTV29 күн бұрын

  What do you do if the image is still only showing a grey default image, rather than the actual image?

• 
  @BetterSheets29 күн бұрын

  My only guess is... Try a different url?

• 
  @cgc230029 күн бұрын

  thank you

• 
  @BetterSheets26 күн бұрын

  👍

• 
  @cgc230029 күн бұрын

  Hello I made a product catalog on Google Sheet then I imported this catalog into WordPress I was wondering if it would be possible thanks to the combination of Google Sheet APIs, WordPress and the use of n8n software that all the keywords present in the description column of each product are automatically replaced by the correct keywords? and the same for images? THANKS

• 
  @BetterSheets29 күн бұрын

  Dont know wordpress or n8n sorry.

• 
  @cgc2300Ай бұрын

  hello I made a product catalog on Google sheet then I brought this catalog into WordPress I was wondering if it would be possible thanks to the combination of Google Sheet APIs, WordPress and the use of n8n software during the sequence that we are going to see and how many times would it be possible for all the keywords present in the description column of each of the products to be automatically replaced by good keywords? and the same with the images

• 
  @BetterSheets24 күн бұрын

  Anything is possible

• 
  @CarlyBlack-teachАй бұрын

  If I create my own images how do I "host" them myself and give them a URL?

• 
  @BetterSheetsАй бұрын

  Maybe imgur?

• 
  @wentzel812Ай бұрын

  This was fun :)

• 
  @BetterSheetsАй бұрын

  Glad you liked it.