Getting Started Coding in Apps Script
HTML-код
- Опубликовано: 13 окт 2024
- What you need to know to access Apps Script inside Google Sheets. Code in Google Scripts. Automate business processes and more.
🔔 Subscribe for more free Google Sheets tips: www.youtube.co...
🕰️ Time Saving Tips, Tricks and Techniques
bettersheets.c...
🤖 Add AI to Your Sheets
bettersheets.c...
🚀 Tools and Templates For YOU:
Generate Google Sheets Formulas:
bettersheets.c...
100 Free Business Ideas - Lead Magnet, product, and business ideas you can make in a Google Sheet to validate your business ideas.
Free at bettersheets.c...
Tiny Sheets - Easily delete unnecessary rows and columns
Free Add-on: tinysheets.bet...
Sheet Styles - Change your spreadsheets style to match your mood.
Get it now: sheet-styles.b...
Atomic Sheets - 100 Spreadsheet elements you can add to your spreadsheets immediately.
30 free: atomicsheets.com/
Generate REGEXMATCH formulas to clean data
bettersheets.c...
Generate SPARKLINE formulas to make cool charts inside of cells.
bettersheets.c...
😎 Most Popular Tips and Tricks
Extract Urls from Google Sheets
blog.bettershe...
⚙️Automate Your Sheets:
Spreadsheet Automation 101, get started making your sheets work for you, while you sleep
Start Automating: bettersheets.c...
Learn to Code in Sheets - A quick course to get you started on Apps Script. Coding in sheets makes automating your sheets so much easier!
Learn here: www.udemy.com/...
📺Step-by-Step Tutorials
Find EVERYTHING you need to make your spreadsheets better on my website BetterSheets.co
Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you.
Thank you for the Basics it really helped me to get started.
Keep going!
hello and thank you very much for giving me templates
I still have a few questions, is it impossible to add several APIs to my Google sheets
this is what I would like to do
hello would this API allow me to do image processing? do you also use software like our automation codes like make? and finally I wanted to ask you another question regarding APIs and Google sheet, do you use this method?
could I write to you
image processing is not that useful in sheets. because images are not in sheets, and so you'd just be using URLs of images online somewhere. and google drive makes it hard to find the actual url of an image saved in a drive folder/file.
It's not impossible but it's hard.
and yes you can add several apis to a google sheet.
hello brother, is it possible that automatically when a member fills in their date of birth data on the Google form, it will be filled in automatically on the calendar, and there will be a birthday notification every year on the calendar?
you can have any automation run "every day" and check for the birthday. so yes this, what you describe, is possible.
How to give Individual Worksheet View, Edit & download Access to Specific Email in one Google Sheet Workbook?
For example: Sheet1 can be viewed, edited & downloaded by Mr. A email only,
Sheet2 can be viewed, edited & downloaded by Mr. B email only, likewise
hello I had an idea of using an API to do automatic image editing
my first idea is to make a robot that could remove the background from my images and put a white background instead
a robot that could scan all the images on my site and remove all the backgrounds and change them to white backgrounds
I thought it would be possible with the canva kind of api
but first I wanted to know if it is possible to do more advanced stuff with the figma API for my background idea
Depends on the figma api. If you can do curl commands to figma api you can use apps script.
@BetterSheets I have a lot of difficulty understanding because I don't know anything about code
do you use artificial intelligence to code? for app script code?
@@BetterSheets hello, do you know api connector?
do you use AI for coding?
can I find "templates" ?
@@chrisder1814 bettersheets.co/snippets
@@BetterSheetsHello and thank you very much, I visited your property but the problem is that I speak bad English and I am a total beginner, do you have videos in which you show how use your scripts and could I send you an email
how does the script reconnect the google form with the spreadsheet on the original sheet
Sorry what do you mean by reconnect?
Hi sir, how to record and run micro sheet 1 and sheet 2 on same time
Wtite the macro so it does both then run it. Maybe learning Apps Script helps
mine doesnt find the formula
didn't work
Did you get an error?
Why start the very first example with a chain of 4 methods, when functions most of the time work with arguments instead of grabbing data from fixed sheet cells? You sure you don't want to scare people as the JS bible did? haha
Will keep trying to make it simpler. I got a few ideas for very simple apps script videos in the near future.