Video

Thank you 🤝

Hello sir, why file pdf isblank from sheet template ,the template fill data from sheet

Спасибо!

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

why does email address not show up execution logfunction mySquarespaceFunction4(){ var authInfo = ScriptApp.getAuthorizationInfo(ScriptApp.AuthMode.FULL); Logger.log(authInfo.getAuthorizationStatus()); //Log the authorization status (REQUIRED or NOT_REQUIRED) const email = Session.getActiveUser.getEmail; //const email = Session.getEffectiveUser.getEmail; Logger.log('bubbakingofbbq'); const id = '1PKG0WlYOhQ40kSq9oMiG50L19r-r82CvSnJDFxD94Fv1xiUq_QtBFlwN'; const doc = DocumentApp.create('Test2'); const body = doc.getBody(); let emailContent = body.editAsText().getText(); Logger.log(doc.getName()); //doc.setName('my email doc'); const subject = doc.getName(); const url = doc.getUrl(); emailContent += '' + url; GmailApp.sendEmail('bubbakingofbbq@gmail.com','whatTheF', 'shittyResults'); Logger.log(email);

Hello Sir, How to replace text with QR from URL?

Hello Sir, how to replace text on google docs with image from url using apps script?

Awesome video😎😎👍👍

37:00 (my pinned)

Thank you for this video. I have no coding experience and this made it very easy to follow and write the code I need.

how can i submit the response by appps script?

good job, but: TypeError: current.getFiles is not a function 🕵‍♂

if I have an external email from hostinger, can I use this function? and how?

When I don’t run a script directly from the code editor (for example adding a button in google sheets that runs a function) I can’t see the log at all. It’s neither in the execution log, nor is it in the console you can find by using inspect element. Thanks in advance.

I'm trying to tie this to a form so that the email from the sheets goes out upon form submission. Is there simple code to add to sheets or should I start over and code the form?

Thanks for your amazing work. How can I add the owner (who created the file) information as a column?

Above and beyond Thank you a million !!!

please i want code to make dirction left to right

how make page language dirction ltr or rtl by programming

Awesome tutorial!! Please help me take it one step further. How can i automate a follow-up email sent to an email in column 2 in 3 months time based on the date in column 4?

Great tutorials! I have learned a lot. Do you have or would you consider making a video for converting date and time to UTC?

Help! I keep getting a TypeError: responses.forEach is not a function.

how to insert a json file from the web taken with fetch api / UrlFetchApp google script into the html dropdown input in google app script, and the input is in the form of a dependent dropdown from province, district, sub-district, village... please make a tutorial

Hello, I am trying to automate a template using a spreadsheet but I seem to be having issues populating multiple fields. I am able to body.replaceText once but when I try to add the others it won't work. How do I know which row number to use? thank you. Example: body.replaceText('{Employee Name}',row[1]) body.replaceText('{Field 2}',row[?]); body.replaceText('{Field 3}',row[?]);

Excellent explanation, super clear. It's just I needed it. Thank you!

Laurence can the web app be located on any server and have nothing to do with the google eco system ?

thank you, can you use the same method to convert pdf to google doc ? (other way around). Preferable with OCR enabled? Thank you!

but I need to know the distances from my current location to multiple GPS coordinates.

How to run a script function as a formula in sheet?

code

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 only, Sheet2 can be viewed, edited & downloaded by Mr. B only, likewise

I have a question, sir. If there is a gmail that comes in every day (bill "pdf") Want to save data from pdf into Google Sheet. (only parts such as date, expenses) Please suggest a method or how to write a good script with great respect.

Hello, greetings. I'm looking for videos that explain how I can create a logging system, that is, I need that when a user with access to the spreadsheet as an editor makes some insertion, change or even deletes a cell from a specific range of a given tab, this information is written in another tab called: "Logs" where ifnrome the date and time of the event, the user's email and what the status of the action was, whether the content was deleted, inserted or changed. Is there any way you can help me with this?

I have a big question about project like it Where can i ask u so 😢😢

Teacher, I need library for students online

Does this give a straight line distance or actual road distance that we get from google maps?

Do you have a video that will help show me how to run a script on 2 different files. I created one to gather data & update information and it works great in my test file but the real use is across 2 different spreadsheets and i can't seem to figure it out.

Thank you for this! I was really struggling to understand how the image was stored in a paragraph, and how to get at it. I find it very weird (frustrating) that Body has getImages(), but Paragraph doesn't.

Amazing class.

Promo sm

VERY useful ‼️ Thanks😍

Thank you very much, this helped me a lot with my project 🙌

Thank you. It's very helpful

Can I add a trigger to this script? Let's say mail to be triggered if the value in certain cell changes - True/False, Yes/No etc

can you make a video to import json data fRom API URL with header request like cookie and user laguage.

wonderful

How can you add multiple people to the recipient list for the emails?

the border and cell formatting is not showing up pls suggest.

Okay, this video is assume. I have one question... could the code be set so IF the Sheet gets a new submission, it automatically runs the Email Out script? Or does the Email Out have to be run manually?

YESSSS!!!! I MADE IT YOUR AMAZING 👏👏👏👏👏