#google script

[codician]

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

  google sheets, billing automation , customized billing, invoice , google app script , how to automate billing , invoice

[montereybayaquarium]

Feeling super amped up that we got Executive Director, Julie Packard, and Chief Conservation and Science Officer, Margaret Spring joining the trend to tell you all about the based things at our Aquarium. They truly were the moment💅✨🌊

[itmlab]

How to Convert HTML to PDF with Google Script? - ITMlab

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.

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

[scrapoddles]

is this avoidance

[gothamite-rambler]

Justice League Trivia Night: Sci-Fi Edition

The Justice League gathered around a large screen for their trivia game night, the topic of choice was sci-fi. Batman, known for his detective skills, had a surprising admiration for sci-fi as well, particularly Star Wars. He was a staunch defender of the prequels and had an encyclopedic knowledge of the franchise.

Wonder Woman: If only one person could be named the central character of the Star Wars saga, it would be Anakin Skywalker, aka Darth Vader. Vader has had many faces and voices over the last 40 years… He has? Name all the actors who either played Anakin, wore the Darth Vader suit, or voiced Anakin/Vader in a film or TV show. Who would actually know this?

Batman (expecting this): And turn.

Superman and Green Lantern both turned to him, anticipation visible on their faces as they waited for him to answer for their team.

Superman: Go ahead, we know you have the answer.

Batman (without taking a breath): Jake Lloyd played young Anakin, Hayden Christensen was Anakin in Episodes 2 and 3, where he also portrayed Vader, which I continually assert was decent for the series. Matt Lanter was the voice of Anakin in The Clone Wars, and Mat Lucas voiced Anakin in Star Wars: Clone Wars the original 2D micro-series.

Hal (Green Lantern): Damn.

Batman: I’m not finished! David Prowse was the man in the suit in movies 4 and 6, Bob Anderson was the stunt Vader and handled most of the lightsaber fights, James Earl Jones provided Vader's iconic voice, and Sebastian Shaw portrayed the unmasked Vader. And-

Hawkgirl (flabbergasted): There's more?

Batman: Yeah, keep up: C. Andrew Nelson appeared in the suit during additional photography for the special editions, Spencer Wilding was inside the suit for part of Rogue One, and finally, Daniel Naprous was inside the suit for the other part of Rogue One.

A stunned silence enveloped the room as everyone processed his rapid-fire knowledge, until Aquaman started clapping, soon joined by the others.

Batman: Yeah, don't ever doubt I'm a fan, because I defend the prequels.

Wonder Woman (impressed): …The fact that all of that information was on the card as the answer, and you got it all correct, astounds me. Points for Team Batman.

Zatanna (team leader for her team): Damn it! You guys suck at this!

Hawkgirl: Oh, don’t come after me! You’re his friend! Why didn’t you know some of that?

Zatanna: I was into Star Trek!

Vixen (regretting): I should’ve sat this one out.

Amid the banter, Batman sat back, arms crossed, a satisfied smirk creeping onto his face, reveling in the glory of not just defending the prequels, but also impressing his teammates with his unexpected expertise.

[annabelle--cane]

it's getting bad again, guys. check in on your friends. recently I've been actively contemplating becoming a video essayist.

[sunlit-mess]

I so badly crave more insight into your Michelin stars AU regarding Alastor and lilith

ESPECIALLY since I saw that one doodle(?) You made of Lilith next to Alastor while he's covered in blood 😭 forgive me for any mistakes as I ask,

Were/Are Lucifer and Lilith married? Did Lilith run a brutal food industry, with Alastor and vox underneath her (you mentioned the two worked together before they split)? Is Alastor some strange hitman guy??? What’s keeping Alastor loyal to Lilith (is it their moral code? Or is there blackmail or something)??

FKRIDHCIQJD THIS AU IS SO GOOD I ALWAYS EAT UP WHATEVER YOU MAKE OF IT

Hehe, lemme cook 🍽 ( sorry for slow service though, I'm focused on commissions this month but I actually finished the script for 2nd part of Chapter 1 )

• Yes, Lucifer and Lilith were married. Until their relationship started to stray, what happens then- u guys will know soon ::)

• (Past) Vox and Alastor worked in the same industry but not under lilith. (Past) Lilith had a different job, but supports Lucifer's dream ^.^

• Alastor is under a contract that keeps his name clean.

A little insight to Vox and Alastor

• They used to be VERY close

• There's a reason behind the person they are today ( present time in the AU )

[neenarchive]

"they had mpreg in middle-earth"

- J.R.R. Tolkien

[roscoehamiltons]

LHFW LHRW 2025 Graphics: Saudi Arabian Grand Prix

[auroraisleaving]

Add yourself to one of my DRs!!

mootie or not, I don’t discriminate! Please fill out the form so I add you as a frienddd (,,> ᴗ <,,)

@rumitome @illicitshifts @vesper-of-the-coven

[jedisupernova]

HEAR ME OUT... top and gd in one fic👀👀

i got this ask in march. i have refrained from answering until now because of an idea i've had since february. but girl its finally time: part i of my challengers au compress, repress with jiyong and seunghyun will be posted this friday at 8pm est!

if you haven't heard of or seen challengers, its a film about so many things but at its core it is a love triangle. their lives become interwoven through tennis, and the sport is used as a metaphor for the human condition, sexuality, and power. its really fucking good and the score is tea. art donaldson altered my brain chemistry. i highly suggest you watch it. my au does not follow the film exactly, and the dynamic between the three are different, but it keeps a lot of its quintessential dna (and scenes like the hotel room, churros, the signal, and more.) the film is on prime, if you're interested! i said before that i was going to talk about my other interests on here. look at me, putting it into my writing tenfold :)

it feels so good to finally tell you 😭 i hope you look forward to it and enjoy it!! see you friday 🩷🎾

[project-sekai-facts]

The text on the book in Tsukasa's trained Star Melody 4* card is a translation of the opening lines of the Pianist Named Torpe play from On the stage of dazzling light. It is slightly different from the official English translation later provided by Hatsune Miku: Colorful Stage.

[dereks-unrelenting-heart]

Yes Google, I do know that the grammar here is shit. Unfortunately these are spoken lines and people don't tend to talk with correct grammar all the time. It will happen again.

[drop-dead-dropout]

posting a kimharry oneshot here bc i'm too lazy to format it on ao3 rn but I'll reblog with the ao3 link later if I get around to it

so basically I was thinking about how kim is very my partner coded and I had this galaxy brain idea to write a fic where kim is asexual or uhhh. would grayace be the term? sorry idk but it's based on my partner I love him <3. also blink and you'll miss it trans harry but it's important to me that you know they're t4t in this lol. cw for suggestive (non-graphic discussions of sexuality and also it takes place Directly after them fucking), 1.3k words. (please be nice to me I've never posted fic on tumblr lol)

YOU — The air in your apartment is musty with the smell of sweat and sex. Your chest heaves with slightly strangled breaths, face burning with humiliation. You've always been a little (a lot) loose-lipped during orgasm—

ELECTROCHEMISTRY — Especially an orgasm like that, holy shit, Kim—

YOU — But you've never, in living memory, said anything quite as ridiculously and unashamedly needy as the complete word-vomit that just exited your mouth a few seconds ago.

REACTION SPEED [Easy: Failure] — Honestly, you were a little out of it and the exact phrasing is already slipping your mind, but it was something along the lines of... What was it again?

ENCYCLOPEDIA [Medium: Success] — Oh my fucking Dei don't stop, Kim please I need you so bad, god I'm so desperate, shit, you drive me fucking crazy, pleasepleaseplease—

SAVOIR FAIRE — Yeah, no, I'm cutting you off right there. He's already about to spontaneously combust, you don't need to embarrass him even more.

ENCYCLOPEDIA — He asked. Besides, I'm not the one who dropped the ball there.

COMPOSURE — Sorry for that, Harry.

KIM KITSURAGI — Kim's hands rest on your chest, tracing circles just below your twin scars with his nimble fingers. "Is that... Really how it feels, to you?"

EMPATHY — It's a genuine question, and he's smiling with an infectious fondness. He's not upset, just curious. Your eagerness is fascinating to him. And cute.

HALF-LIGHT — What does he mean by that, though? Are we too needy? Is it not good for him? Does he hate us and want us to die forever—

VOLITION — No. Shut up. We already agreed you're not allowed to talk when Harry's alone with Kim, don't you remember?

HALF-LIGHT — But! Danger!

ESPRIT DE CORPS [Trivial: Success] — It's Kim. There is no danger here.

YOU — At a loss for anything else to say, you just nod, a bit dumbly. "I mean... Yeah. Is it, uh, not like that for you?"

COMPOSURE [Formidable: Failure] — You try to play the question off as a nonchalant, but you're not even close to being a good enough liar to hide the mild undercurrent of fear in your voice. Especially not from him. (Khm. Sorry again.)

KIM KITSURAGI — "No, not really. It's not you," he quickly adds, seeing the obvious and barely-held back self-loathing in your expression. "It's just the way I am, I suppose. I'm too old to question it now."

DRAMA [Heroic: Success] — He's not lying to spare your feelings, sire. This is truly just a facet of himself that's always been there.

RHETORIC [Challenging: Failure] — By the way, you distinctly recall hearing him talk about having had sex before. Quite a bit, in fact.

YOU — "But wait, I thought—"

KIM KITSURAGI — Already having anticipated this line of questioning, Kim laughs a bit under his breath. "It wasn't a lie; I never said I don't. Actually, sometimes that made it better— without all the messy urgency, I guess I seemed 'cool', to borrow your phrasing. And it's not like I didn't enjoy it, either." He shrugs. "It was just... Something to do. I never really understood the intensity."

SHIVERS [Legendary: Success] — A dozen miles and many years ago, two young men make out in a musty old apartment. "How are you always so— so unaffected," one says to the other with a breathy laugh. In a few months he will repeat these words with a much uglier tone, and they will be the last ones Kim ever hears from him.

EMPATHY [Heroic: Success] — For the record, he was not, in fact, "unaffected" by that particular heartbreak. Don't ever hurt him like that.

YOU — Before you can think better of it, you find yourself saying, "Is that bad?"

KIM KITSURAGI — A twitch in the corner of his mouth interrupts his relaxed grin for a moment. You almost want to mourn the loss. "I don't know, Harry, is it? Why do you think it would be?"

PAIN THRESHOLD — You've hurt him, idiot. We just told you not to do that.

YOU — "I-I mean— it's just—" Your teeth click audibly with how quickly you shut your own mouth. You really, really don't want to fuck this up.

HALF-LIGHT — Too late.

VOLITION [Challenging: Success] — HEY. Back in the corner, you.

YOU — Guys, please help me. I don't know anything about… Well, anything, really, but especially not this. How do I fix it? What do I say to make him feel better?

INLAND EMPIRE — You could start by actually answering his question, instead of rushing to apologize. Why do you think it would be bad? What about the concept is uncomfortable to you?

SUGGESTION [Medium: Success] — Kim feels safe with you, in the same way that you do with him. Be honest. He knows you didn't mean anything by it— the only way you could fuck this up is by not talking to him.

YOU — After a moment of pondering, you find the right words. Or maybe not the right words, but the ones that feel the most true: "I don't know. But I know I would be unhappy, if I was... Different to how I am now."

EMPATHY — Kim's eyes flash with a bit of surprise. But good surprise, like an old friend dropping by unexpectedly. The smile returns (yay!)— smaller, but softer, and almost giddy. It's not one you see on him often, a bit too unguarded and juvenile for his tastes. It's the most beautiful thing you've ever seen.

KIM KITSURAGI — "So would I," he says simply.

DRAMA [Challenging: Success] — He means it.

YOU — "Oh." You blink two or three times. "Oh. Well that's good, then, right? That you're happy?"

PERCEPTION (HEARING) — Something about the almost childish sincerity in your voice must be funny to him, because he keeps doing that thing where he chuckles under his breath, and coughs to try to cover it.

PAIN THRESHOLD [Formidable: Failure] — He's laughing at you.

AUTHORITY [Trivial: Failure] — Exactly. He's mocking you, Harry, he thinks you're an idiot. Make him respect you—

EMPATHY [Easy: Success] — He's in love, you moron.

ELECTROCHEMISTRY — As if on cue (or maybe your internal dialogue is just more easily observable from the outside than you thought), Kim leans forward and kisses you. For the first time, you notice how effective he is at responding to your reactions, like he's trying to find and wring out every last happy sigh and spark of oxytocin he could possibly give you.

INTERFACING [Medium: Success] — Because he likes this. He likes pressing all your buttons and seeing what they do, which ones work the best. (Almost all of them work, when it's him. Maybe a little too well.)

ENDURANCE — Hey, don't look at me like that! It's not my fault he doesn't play fair.

SAVOIR FAIRE — Exactly. How are we supposed to be cool in front of Kim? He's like, the coolest.

KIM KITSURAGI — "I love you," Kim whispers, his lips tickling against your collarbone.

SAVOIR FAIRE — See?! He even makes THAT sound cool, a thousand times cooler than when we say it, which is, like, every five seconds!!

EMPATHY — It's true that you're usually the one to say it first. For a time, he hardly said it at all— you learned not to take it personally. You certainly have your own baggage. But lately, it's been nice to watch as he gets a bit more comfortable.

EMPATHY [Formidable: Success] — The cuddling usually seems to help, in moments like this.

CONCEPTUALIZATION [Godly: Success] — After all, what is a hug but a way to hide your face?

YOU — You wind your arms tighter around him. "I love you, too, Kim." And you swear he must be able to feel the way your lungs glow.

EMPATHY — He does. Of course he does.

INLAND EMPIRE — For a moment, you think you can feel his, too.

SHIVERS [Legendary: Success] — SLEEP WELL, MY DARLINGS.

[gothamite-rambler]

Stephanie is a booktok spicy girlie

*this is a real excerpt from the book*

Stephanie (reading from the book): “Such a pretty pussy, Anastasia,” I praise, running my COCK between her FOLDS, watching the goose bumps spread across her back when the TIP nudges her. “Hurry up and FUCK it then.” She sighs when I line myself up. “Please-

Jason: Stop reading the book out loud!

Barbara (having read this book five times before): Until I get comfortable. Oh this is getting spicy.

Barbara gracefully slid out of her wheelchair and rested her arms behind her head. Dick and Jason stared down at her then sighed.

Barbara: Read on.

Stephanie (continuing to read and emphasizing certain words): “So impatient,” I coo, holding onto her hips tightly as I PLUNGE into her, gasping at how WET she is.

Dick: Okay, why are you reading it like that?

Stephanie: To emphasize the words. God, this is one of the few times I use curse words, either leave or keep listening to the spicy romance!

Jason (while leaving): This isn't spicy, which is a stupid word, it's porn! You are reading porn!

Stephanie: We call it spicy!

[reddieswift]

on today's episode of small details from the IT book that are extremely important to me, LOSERS CLUB HANDWRITINGS ARE U KIDDING