#google script

Been learning about psychology and economies at AIE in order to improve our skills as Game Designers.

In order to explore this more we have been creating prototypes of our own games so we can test the economy in the game.

Billing / Invoice Automation using Google Sheets

Billing / Invoice Automation using Google Sheets

 ⭐️⭐️GITHUB

https://github.com/deepaklohia/google-sheets-billing-automation

⭐️GOOGLE SHEET SAMPLE

https://docs.google.com/spreadsheets/d/e/2PACX-1vSxUi1KfkWOINQlqagJX1ZFZy5FMFmMwxItVXuuHHZw8TpyvhFUxNY8KrDnd9yHMJ1r2Zjr-GWP1E8b/pubhtml

 ➡️ Google Sheets Fully Functional  Free Add-ons

⭐️Google Sheets Attendance Tracker

https://workspace.google.com/marketplace/app/attendance_tracker/602607637436

⭐️Google Sheets Time Tracker

https://workspace.google.com/marketplace/app/time_tracker/182790105381

⭐️Google Sheets Combine Sheets

https://workspace.google.com/marketplace/app/combine_sheets/405522851504

⭐️Google Sheets TimeJet

https://workspace.google.com/marketplace/app/timejet/531257058624

 ➡️OTHER USEFUL VBA AUTOMATIONS

how to extract notepad data in excel | VBA Automation

https://youtu.be/xHr7WXjK4dc

 how to get Developer tab in MS Excel

https://youtu.be/DKj2YqcP9cA

 How to run any exe file using VBA

https://www.youtube.com/watch?v=WCFLHf0QbE8

 Excel macro to convert pdf to excel

https://www.youtube.com/watch?v=jeJR_v6TZOQ

 Attendance tracker (custom ribbon)

https://www.youtube.com/watch?v=AU5lbtVVL4M

 file inner text / content replacer - find and replace text

https://youtu.be/Cqi4xtJdOso

 Excel Macro to convert pdf to Excel

https://youtu.be/jeJR_v6TZOQ

 how to merge excel files

https://www.youtube.com/watch?v=AB9dJ_0bwo4

 how to track time and motion

https://youtu.be/sBknyAEBPMU

 send birthday greeting automatically

https://youtu.be/1jFJ35ZPR_A

 connect excel to word / create  letters in word automatically

https://youtu.be/ZgZHY4mOOvY

 automated sop / workflow designer

https://youtu.be/7aNVmmYneZQ

 Send bulk emails in outlook

https://www.youtube.com/watch?v=tDIOenSdN80

 extract outlook attachments

https://www.youtube.com/watch?v=Wq83KruKUyk

 Outlook email extractor VSTO Plugin

https://youtu.be/jg3EWdvjPS0

 how to remove password from MS Access database permanently

https://youtu.be/Zc87eBV3Maw

 Similarity finder / Advanced lookup

https://youtu.be/1Mcchh1rBjU

 Excel to notepad

https://youtu.be/wlO5TyC1x00

 bulk legal letter generator

https://www.youtube.com/watch?v=7-iv3L-lvBY

 simple attendance tool

https://youtu.be/AU5lbtVVL4M

 Excel randomizer for random records

https://youtu.be/4dLTVfTB3I0

 Excel html editor

https://youtu.be/J76SpjwhMtA

 email domain name remover

https://youtu.be/hqx5xP1Rc4o

The Google Script is a powerful tool that allows you to automate repetitive tasks in Google. It allows you to create JavaScript-based applications that use Google services. The following code can be used to convert HTML files into PDF:

For more information: How to Convert HTML to PDF with Google Script? - ITMlab

Convert HTML to PDF

Converting HTML to PDF is easy. You can do it yourself, or you can use Google Script to do it for you.

To convert HTML to PDF using Google Script:

Create a new script in Google Drive and name it “ConvertHTML.”

In the “Code” section at the bottom of your script editor window, copy and paste this code:

var docs = SpreadsheetApp.openByUrl( ‘https://docs.google.com/spreadsheets/d/YOUR_SPREADSHEET_ID_HERE’ ); var sheets = docs.getSheets(); var sheet = sheets[0]; var rows= sheet .getRange( ‘A1’).getValues();

1. Create an HTML file that has a table of contents, headers and footers

Before you can convert HTML to PDF, you’ll need to create an HTML file that has a table of contents, headers and footers. Here’s how:

Open Notepad or another text editor on your computer (if you’re using Google Chrome, then we recommend using the built-in Developer Tools).

Type out some basic text like this:

Create a table of contents by adding tags around each major heading in your document; if there are no major headings in your document yet (you haven’t started writing), then type out some more text until there are multiple levels of headings so that we know where our table should begin! For example:

This is my first Heading, This is my second Heading. Make sure these tags are indented with two spaces from each side so that we can tell them apart from regular paragraphs later when we convert them into actual tables!

2. Save the file as an HTML file with a .html extension

Save the file as an HTML file with a .html extension

Make sure you have the right extension. If you don’t, Google will not be able to open it and convert it into a PDF file. You can also save it as a text file and then open it in a browser to see if it works.

3. Open your Google Drive account in your browser and log in if you haven’t done so already.

You need a Google account. If you don’t already have one, go to https://accounts.google.com/signup and follow the instructions to create one.

You’ll need to be signed in to your Google Drive account. If you haven’t done so yet, sign in using your email address or phone number associated with the account (the same credentials used for Gmail).

Sign out of Google Docs if it’s currently open: Click on “File” at top left corner of screen then select “Account settings” from dropdown menu under My Drive section at right side of page; next click on “Sign out” link at bottom left corner of window that appears when hovering cursor over ‘My Drive’ heading before signing back into new window where we will begin creating our script file below this paragraph!

4. Click on the “Script” option in the left-hand sidebar menu at the top of the screen (or click here)

The next step is to click on the “Script” option in the left-hand sidebar menu at the top of the screen (or click here). This will open up a window with some code that looks something like this:

var doc = DocumentApp.openById(‘myDocumentId’);

doc.setHtmlContent(‘Hello World!’);

5. Click on “Create from URL” and select ‘Create a copy…’. Then paste in this script code into the “Script Editor” box that appears below htpps://docs.google.com/spreadsheets/d/1L0N37Nrka0lQ2c3qpx3YB–e_pIg1__jZQbzswrItxM/edit#gid=269221153

Click on “Create from URL” and select ‘Create a copy…’. Then paste in this script code into the “Script Editor” box that appears below htpps://docs.google.com/spreadsheets/d/1L0N37Nrka0lQ2c3qpx3YB–e_pIg1__jZQbzswrItxM/edit#gid=269221153

You can also use the Google Spreadsheet API to convert HTML to PDF, but it requires some technical knowledge about coding languages such as Javascript or Python.

This is a great script if you want to convert your HTML files into PDFs. It’s easy to use and it has all the features that you need in a script like this one. If you want to convert your HTML files into PDFs, then this is a great script for you. It’s easy to use and it has all the features that you need in a script like this one.

One of my goals today was to disable the use of the form add-on we were using to send email notifications to our staff and customers/clients who submitted the contact form on our website. Using Google Apps Script, I did it in a couple hours. The add-on was okay, but if I know I could code something that I understood the mechanics of, then why wouldn’t I?

This code should be put in the Script Editor of your Google Form:

// retrieve all information that is given in the contact form // send a response message right away to the submitter, detailing their submission // send a message to the service team effectively describing the person's contact query and all information given function sendEmails(e) { // gives an array var responses = FormApp.getActiveForm().getResponses(); var length = responses.length; var lastResponse = responses[length-1]; // gives another array var formValues = lastResponse.getItemResponses(); var name = formValues[0].getResponse(); var email = formValues[1].getResponse(); var subject = formValues[2].getResponse(); var message = formValues[3].getResponse(); // customer service team email var csEmail = ''; if (subject == "") { // email subject for the cs team to see var subjectCS = 'A Message Has Been Sent to Customer Service Team from ' + email; // email subject for the submitter to see var subjectSUB = 'Your Message Has Been Received'; } else { // email subject for the cs team to see var subjectCS = 'A Message Has Been Sent to Customer Service Team: ' + subject; // email subject for the submitter to see var subjectSUB = 'Your Message Has Been Received: ' + subject; } // form the body of the email for the cs team to see var bodyCS = name + ' has sent this message to the Customer Service team through the website contact form: ' + message; // send email notification to the customer service team MailApp.sendEmail({ to: csEmail, replyTo: email, subject: subjectCS, htmlBody: bodyCS }); // for the body of the email for the submitter to see - like a reciept var bodySUB = 'You have submitted the following information for our team to take a look at: Message: ' + message + ' We will get back to you shortly with a response.'; // send email to the submitter MailApp.sendEmail({ to: email, subject: subjectSUB, htmlBody: bodySUB, noReply: true }); }