Automating With Google App Scripts and Chat GPT (Beginners Friendly)

Yaron Been From EcomXFactor
3 Mar 202432:17

Summary

TLDR本视频讲述了使用Google应用脚本和GPT进行自动化处理的理论和实践,包括通过Google应用脚本发送电子邮件和日历邀请的例子。视频还介绍了使用Chrome扩展程序Automa进行浏览器自动化的经验,以及与Microsoft Power Automate的比较。此外,作者分享了解决自动化问题的方法,强调了熟悉工具全面功能的重要性,并展示了如何利用Google应用脚本创建个性化的PDF邀请和自动化日历事件。最后,视频强调了在自动化过程中尽可能减少工具转换的重要性,并提供了一些提高效率的技巧。

Takeaways

  • 🔧 在尝试解决自动化问题时,首先通过谷歌搜索和Stack Overflow寻找解决方案,优先考虑高赞的回答。
  • 🌐 探索新工具如Automa时,重要的是要阅读其文档,了解所有功能,这有助于发现更高效的解决方案。
  • 🔄 尽管Automa提供了平台无关性和灵活性,但它可能不如Microsoft Power Automate强大,并且可能存在一些bug。
  • 💡 使用Automa和Google应用脚本等工具进行自动化时,了解工具的所有功能非常关键,这有助于提高工作效率。
  • 📚 在开始使用新工具或软件时,通过阅读完整的文档和观看相关教程视频,可以更全面地理解其功能和使用方法。
  • 👩‍💻 利用Google应用脚本进行自动化时,通过Chat GPT来编写和调试脚本可以有效节省时间和提高准确性。
  • 📅 使用Google应用脚本可以自动化一系列任务,如发送定制化的邮件和创建日历事件,提高了工作效率。
  • 📈 在处理Apollo导出的潜在客户数据时,正确使用筛选器可以显著提高潜在客户的质量,从而提高自动化流程的效果。
  • 🖥️ 在自动化过程中,尽可能在单一工具内解决问题,避免过多使用连接器或额外的工具,以减少复杂性和提高效率。
  • 🔍 在解决自动化挑战时,不仅要搜索在线解决方案,还可以利用GPT模型和GitHub的问题跟踪来寻找或验证潜在的解决策略。

Q & A

  • 谷歌应用脚本与自动化有什么关系?

    -谷歌应用脚本用于自动执行诸如发送电子邮件和日历邀请等任务,它是一个强大的工具,可以提高工作效率和自动化重复性任务。

  • 什么是Automa,它如何与其他自动化工具比较?

    -Automa是一个Chrome扩展,允许用户创建浏览器自动化流程。与Microsoft Power Automate相比,Automa是平台无关的,并提供更多自由度,但可能不如Microsoft Power Automate功能强大,且可能包含一些错误。

  • 为什么说“没有解决方案,只有权衡”?

    -这句话表达了在选择自动化工具时经常需要权衡不同工具的优缺点,没有完美的解决方案,只能根据具体需求选择最合适的工具。

  • 在自动化过程中遇到问题时,应该如何寻求帮助?

    -首先,通过谷歌搜索和Stack Overflow查找解决方案;其次,利用Discord等社区资源;再次,通过阅读文档和使用GPT等工具来获取帮助。

  • 使用新的自动化解决方案时,为什么了解所有功能很重要?

    -了解所有功能可以帮助你充分利用工具的潜力,避免不必要的工作和错误,确保你能高效地自动化业务流程。

  • 如何有效地利用Apollo进行前期筛选来提高自动化流程的效率?

    -通过使用Apollo的筛选功能,比如公司规模、使用的技术和关键字等,可以在自动化流程的早期阶段筛选出更相关的潜在客户,从而提高整个流程的效率和结果质量。

  • 谷歌应用脚本在自动化中如何使用?

    -谷歌应用脚本可以用来从Google Sheets中提取数据,创建个性化的PDF文件或电子邮件,并自动发送这些文件。它也可以用来创建和发送日历事件,显示出极高的自动化和个性化能力。

  • 为什么理解工具的全部功能对自动化来说很重要?

    -理解工具的全部功能可以帮助你更高效地解决问题,并可能发现更简单或更强大的方法来执行任务,从而避免不必要的复杂性和额外的工具使用。

  • 如何使用GPT来辅助自动化脚本的编写?

    -可以将需要自动化的任务的细节输入到GPT中,GPT可以帮助生成或改进自动化脚本的代码,提高编写效率和准确性。

  • 探索Google应用脚本的价值有哪些方法?

    -通过阅读官方文档,查看Code labs上的教程和案例学习,以及实际编写和测试脚本来探索Google应用脚本的功能和潜力。

Outlines

00:00

👨‍💻 介绍自动化过程中遇到的困难,以及解决方法

分享最近在使用 UTA 工具自动化过程中遇到的一些困难,主要集中在工具本身的限制,以及后续想要商业化该自动化流程时出现的挑战。介绍了自己是如何解决这些困难的,包括 Google 搜索、查阅 Stack Overflow、Discord 论坛、閱读工具文檔以了解全部功能等方法。这使我认识到 Google App Scripts 的强大功能,可以实现我想要的自动化。

05:01

📊 分享爬取Apollo数据的案例,强调了解工具功能的重要性

分享了一个客户使用 Apollo 导出大量低质量销售线索数据,然后需要我用自动化流程进行处理加工的案例。后来发现客户在导出数据时没有充分利用 Apollo 的过滤功能,导致输出的线索质量很低。在指导客户添加更多筛选条件后,相关线索的比例大大提高,证明了解并充分利用工具已有功能的重要性。

10:03

📚 重点阅读文档,观看教程视频,以充全利用工具的全部功能

每当使用一个新工具时,都会优先閱读全部文檔,观看 2 小时左右的 YouTube 教程视频。这可以让我全面了解该工具的所有功能,避免局限在已知的功能上设计自动化流程,而错过可以直接利用的更好方案。这也是我在学习 UTA 工具时遇到的情况。

15:05

🔎 Apollo数据筛选案例,证明了解工具的重要性

继续讲述 Apollo 数据筛选的案例。指导客户在导出数据前,添加更多筛选条件,如技术指标、关键词、地区等。这极大地提高了输出数据的质量和相关性,自动化流程的效率也得到大幅提升。再次证明了解和利用工具的全部功能至关重要。

20:06

💡 展示Google App Scripts的自动化示例,证明其强大的功能

通过一个示例展示了 Google App Scripts 的部分自动化功能,包括 reading 谷歌表格数据、动态生成 PDF、发邮件和日历邀请等,交互式演示了整个流程。这证明 Google App Scripts 功能强大,完全可以实现我之前想通过 UTA 实现的自动化。

25:07

📧 Google App Scripts自动发送个性化电子邮件和日历邀请

基于谷歌表格的数据,Google App Scripts 可以自动为每位接收者生成个性化的 PDF 附件,并通过电子邮件发送给对应的邮箱地址。另一个脚本可以根据表格数据,自动在 Google 日历中创建约会事件。这些自动化操作快速、高效,展示了 Google App Scripts 的强大实用性。

30:10

🤝 建议尽可能在单一工具内解决自动化,避免引入更多复杂性

视频最后,分享了一个自动化专家的建议:尽可能在单个工具或平台内解决自动化流程的全部步骤,避免引入像 Zapier、n8n 等额外的连接器或平台,从而增加过程的复杂性。这是一个值得参考的经验。

Mindmap

Keywords

💡自动化

自动化是视频的核心主题。它指通过程序或者脚本实现业务流程的自动执行。视频讲解了使用不同工具实现自动化的过程,比如自动发送邮件和日历邀请。

💡谷歌应用脚本

谷歌提供的用于自动化任务的编程工具。视频最后讲解了使用谷歌应用脚本自动生成并发送个性化的pdfs。

💡疑难解答

解决自动化过程中遇到的各种技术难题的过程。视频详细描绘了作者debug自动化流程的思路。

💡自动发送邮件

自动化流程的常见场景之一,即通过程序自动批量发送不同内容的邮件。视频中通过谷歌应用脚本实现了这个功能。

💡效率

自动化核心目标之一是提高业务流程的效率,这在视频中多次提及。汲取工具提供的各功能,避免流程过于复杂化,都是提高效率的方式。

💡日历邀请

自动发送日历邀请也是一个常见的自动化场景。视频展示了如何用谷歌应用脚本自动发送不同时间的日历邀请。

💡个性化

即为每个接收者提供特定针对性内容。视频展示了如何自动为每个接收者生成个性化的邀请函等文档。

💡Apollo

一种lead生成与管理工具。视频讲述了使用Apollo的过滤功能提高对应Automation流程的效率。

💡动态文档

即可以替换个性化变量的文档模板。视频展示了如何结合表单数据动态生成pdf并发送。

💡ChatGPT

一种基于AI的问答工具。视频中作者使用其自动生成了谷歌应用脚本代码。

Highlights

第一个重要的重点文字

第二个显著的重点文字

Transcripts

play00:00

automating with Google app scripts and

play00:03

GPT today is going to be a bit more of

play00:07

a

play00:09

theoretical video with a very

play00:12

interesting examples at the

play00:14

end in which I'm using Google app

play00:17

scripts to automate important tasks such

play00:20

as sending emails and sending calendar

play00:24

invites but before I dive into it I want

play00:27

to share with you what I've been doing

play00:28

in the last three days I've been trying

play00:30

to automate a process in UTA and aoma is

play00:36

this amazing Chrome extension that I

play00:38

found the other day and I created a

play00:40

video about it basically aoma allows you

play00:44

to create um browser automation flows it

play00:48

has a ton of Alternatives you can

play00:51

trigger using um URLs using sending

play00:56

files schedule triggers you can scrape

play01:00

websites you can record any movements

play01:04

that you do in the browser and then have

play01:06

the workflow ready it just endless

play01:10

opportunities and the thing that I liked

play01:12

most about automa in opposing to

play01:14

Microsoft power automate that was the

play01:17

tool that I've been using mostly for all

play01:19

all of my automations so far I mean the

play01:22

majority of my automations was the fact

play01:25

that automa is platform agnostic so it's

play01:28

not specific for Microsoft and it also

play01:31

it is also a

play01:33

Chrome extension which provides a lot of

play01:37

freedom in opposing to Microsoft power

play01:39

automat that some people if they don't

play01:42

use Microsoft they will need to have a

play01:45

VPS

play01:46

installed and this is this causes some

play01:50

sort of friction so I have automations

play01:53

that I've created in Microsoft power

play01:55

automate and I wanted to implement them

play01:58

in automa as well

play02:00

but uh I heard the other day an

play02:04

interesting quote that I liked it said

play02:06

there are no Solutions only

play02:10

tradeoffs no Solutions only tradeoffs

play02:12

and this is correct so although AA is

play02:17

amazing as I told you and it provides a

play02:19

lot of flexibility it isn't as powerful

play02:22

as Microsoft power

play02:24

automate and uh it also has some few

play02:28

bugs that I encount

play02:30

in opposing to Microsoft power automated

play02:32

has a huge theme behind it and keeps on

play02:35

being updated anyway in the last few

play02:37

days I've been struggling to get this

play02:39

automation running and I was able to

play02:42

solve this but I also wanted to added to

play02:45

add a layer that will allow me to

play02:48

distribute um the

play02:50

Automation and also charge for the

play02:54

Automation and this is where I I

play02:56

encountered many challenges basically

play02:58

this is the automation by the way way

play03:00

it's one of the automations it goes to

play03:02

Facebook um sorry about that it Loops

play03:06

through a Google spreadsheet which H

play03:08

contains many URLs many Links of

play03:11

prospects it Loops through each one of

play03:14

them it sends a friend request it sends

play03:17

a like of the recent

play03:19

post and then it sends a DM based on

play03:22

what we input so let's say hi I'm

play03:25

selling X Y and Z or whatever and then

play03:27

it updates the Google sheet and moves on

play03:30

to the next Prospect so this is

play03:31

basically the

play03:33

Automation and I've been struggling to

play03:35

make this work um and I wanted to share

play03:39

with you the process that I've gone

play03:41

through in order to try to solve this

play03:43

and then we will move on to another

play03:46

takeaway with regards to

play03:49

automation um and then we will cover the

play03:52

last example which is using Google app

play03:54

scripts which is way more powerful than

play03:56

I

play03:57

knew um Okay so

play04:00

whenever I encounter an issue in when

play04:04

I'm automating first of all what I'm

play04:07

doing obviously is I Google search I go

play04:12

to stack Overflow and I see what is the

play04:15

most upvoted

play04:17

solution stack Overflow let's see an

play04:22

example power automate not opening Excel

play04:30

so you can see here this is by the way

play04:34

you can either go to the specific um

play04:37

quote unquote I don't know how to call

play04:39

it it's not stock overflow but there are

play04:41

like dedicated forums of your specific

play04:45

solution of the specific software that

play04:47

you're using so for example in this

play04:50

case we can see here someone open this

play04:53

query the power automate will not launch

play04:56

and you can see here it was solved and

play04:58

then you just sort by the amount of up

play05:01

vote so if people that also stuggled

play05:04

with the issue are going to up vote the

play05:07

solution provided so you can assume that

play05:09

this is the best solution so I just

play05:12

start testing Solution by solution based

play05:15

on the amount of up votes and this is

play05:17

also relevant for stock

play05:19

overflow so you can see here someone

play05:22

asked

play05:23

question and you can see here someone

play05:26

answered as we can see there are no of

play05:29

Vols but let's look for a

play05:32

different answer this is okay so this is

play05:35

a question why doesn't canand which

play05:38

faces skyro rocketing rent prices build

play05:41

housing to control the price of rent its

play05:44

politics it's stacking change and you

play05:46

can see here that 17 people have voted

play05:48

this

play05:50

response so this is the first thing that

play05:52

I'm doing I

play05:53

usually do Google Search and then I try

play05:58

all the solution that I see in stock

play05:59

overflow or in the dedicated forums of

play06:02

the solution next I'm going to look in

play06:05

Discord in the dedicated Discord and UTA

play06:08

has a dedicated Discord and over there I

play06:11

also looked for the solution like in the

play06:13

search um functionality of Discord

play06:18

nobody encountered similar solution

play06:22

similar problem or challenge similar to

play06:25

mine so unfortunately I didn't find the

play06:28

solution from the

play06:30

search and then I posted in the Discord

play06:32

if anyone can help me and I did so I

play06:37

tried posting the question pretty early

play06:40

because while because I want to post the

play06:43

question fast and then have let people

play06:47

the opportunity to answer me while I'm

play06:50

also looking for solution so I try to

play06:54

work simultaneously first of all trying

play06:56

to collect the collective wisdom and

play07:00

asking my peers and in the meantime also

play07:02

looking for the solution on my

play07:05

own what I did afterwards is I went to

play07:09

GPT and I opened the

play07:11

documentation and this leads me to the

play07:14

next

play07:15

step and this is a takeaway that I

play07:19

started implementing I think like two or

play07:21

three years ago and I also share it with

play07:24

a lot of with people that I teach

play07:27

automation or any business process so

play07:30

whenever I start working with a new

play07:32

solution I make it a

play07:34

point to get familiar with the all the

play07:38

features that the solution is offering

play07:40

so it is very important as soon as you

play07:43

start working with a new solution that

play07:45

you read through the whole

play07:47

documentation just to give you a scope

play07:49

of the abilities that the solution

play07:52

provides because very often we want to

play07:56

automate a business

play07:58

process

play08:00

and we

play08:02

try using connectors let's say Z or work

play08:09

arounds

play08:11

but the actual solution resides in the

play08:16

software but we are just not aware of

play08:17

the ability of this that the software

play08:19

provides let me come up with an

play08:22

example so let's say we are using email

play08:26

marketing an email marketing software

play08:29

and we are not aware that we can create

play08:32

our own custom fields and use them as

play08:36

Dynamic fields in the email template so

play08:39

let's say the address we can pull the

play08:42

address from the database the address of

play08:44

the the physical address of the prospect

play08:48

we can pull

play08:49

it and send it dynamically to all the

play08:52

emails like per uh recipient will get an

play08:56

email with his own address so so if

play08:59

you're not aware of this feature that

play09:01

you can create your own customer custom

play09:04

parameters um you're going to be stuck

play09:07

looking for a work around or a solution

play09:10

while this is actually something that is

play09:12

being being offered by your solution so

play09:16

for example when I was when I started

play09:18

working with otoma I made it a point

play09:21

first of all to read all the

play09:24

documentation just go over and see the

play09:27

the functionalities and I also try to

play09:29

dedicate at least one or two hours on

play09:32

double X in 2x speed of watching uh the

play09:36

the most the top rated YouTube video

play09:40

YouTube tutorial for

play09:41

beginners about the solution in this

play09:44

case in AAS I don't have many tutorials

play09:46

but I also did this because once you see

play09:50

the top voted solution in YouTube the

play09:52

top voted tutorial for the solution you

play09:54

get a better understanding of how people

play09:57

utilize the tool and

play10:00

it just gives you a better overview of

play10:03

how you can use the tool in opposing to

play10:05

diving to diving right into the solution

play10:08

and then you're missing a lot of

play10:09

functionalities and you also might be

play10:11

setting up the tool

play10:13

incorrectly and I think this is a very

play10:16

important H lesson or takeway that I've

play10:19

been trying to implement every time that

play10:21

I'm using a new software and I

play10:25

understand the urge of trying to dive

play10:27

right into the things and understanding

play10:29

and messing around and and learning by

play10:31

trial and error which is also great but

play10:34

I do think it it would it is a wise

play10:36

choice to make it a point at least to

play10:38

read the whole documentation and watch

play10:40

like two hours video tutorial about the

play10:44

solution so um I what I did I looked for

play10:50

the solution over here and this was

play10:52

actually very helpful I found that the

play10:56

Expressions part of the solution might

play10:58

be relevant for my knees and I mean this

play11:00

was the thing that I wasn't able to

play11:02

figure out so I just copied the whole

play11:06

thing and I pasted it in in chat GPT and

play11:09

I asked chat GPT to write the variables

play11:11

in their correct format based on the

play11:14

automa documentation and based on what I

play11:17

pasted and it was actually able to spit

play11:19

out the variable in the correct syntax

play11:23

which I wasn't able to create so I might

play11:27

you might think that I'm dumb but it is

play11:30

what it is I just wasn't able to figure

play11:32

out the

play11:33

correct syntax because it was like a

play11:36

nested name inside the name and this the

play11:40

the

play11:41

auta naming convention or the way that

play11:43

they use variables is not

play11:45

straightforward at least in my opinion

play11:48

so I leveraged I leveraged I leveraged

play11:51

jgpt for this another alternative which

play11:54

I've done in the past was

play11:57

downloading the whole documentation and

play12:00

uploading it as a knowledge base to CH

play12:03

GPT or whichever framework that you

play12:06

would like to use that has a knowledge

play12:08

base so this is another

play12:10

alternative

play12:12

um and the last thing that you can do is

play12:16

going to GitHub to the GitHub

play12:20

repository and go to the issu section so

play12:23

GitHub

play12:27

automa

play12:29

issues and over here you can

play12:33

see the open issues so if you see open

play12:37

issues these are issues that other users

play12:40

are encountering and some of

play12:43

them I mean sometimes there is just a

play12:46

bug in the platform that is still wasn't

play12:49

fixed and you might be encountering the

play12:52

bug so it's very important to take a

play12:54

look in the GitHub repository in the

play12:56

issue

play12:57

section to to make sure that you're not

play12:59

not just bangging your head against the

play13:01

wall trying to solve something when

play13:04

there is actually a buag and this is

play13:06

very frusterating

play13:07

understanding that you've tried

play13:10

different workarounds and looked up and

play13:13

invested a lot of time looking for

play13:15

Solutions online and then figuring out

play13:17

it's just like you were doing everything

play13:18

correctly but there is just a bug in the

play13:20

platform so it might make sense to check

play13:23

the issues section very soon in your t t

play13:27

shooting process

play13:30

okay so that was the end of that this uh

play13:32

was like a short intro regarding

play13:35

troubleshooting and what I've been

play13:37

encountering in the last few days and

play13:39

this um I'm going to transition to a

play13:42

story about Apollo scraping so the other

play13:45

day I had a client of

play13:47

mine and they wanted to automate a

play13:50

process a workflow in which they

play13:54

exported emails

play13:57

from Apollo

play13:59

and then they wanted to enrich the data

play14:01

using data from the website of the

play14:04

prospects and using data from H Facebook

play14:08

their Facebook ad library and different

play14:10

data

play14:12

sources and we build the Automation and

play14:14

those automation basically was working

play14:17

just fine but it took a lot of time and

play14:20

then um I told them listen how are you

play14:24

exporting the lead from Apollo and when

play14:27

we discussed regarding the way that they

play14:29

export the lead from Apollo we

play14:31

understood that they are exporting in a

play14:34

non-efficient or non- effective manner

play14:37

because they didn't leverage the filters

play14:40

that Apollo is

play14:41

offering and this is related to what I

play14:44

mentioned before so if you start using a

play14:48

tool a service provider such as AP poloo

play14:51

or any service provider and you're not

play14:53

aware of the

play14:54

abilities you might be losing a lot of

play14:57

time or wasting a lot of energy

play14:59

doing stuff that is not effective so in

play15:02

this example they gave me a ton of

play15:05

leads um from Apollo and then I did the

play15:07

automation the automation had to qualify

play15:11

the leads and see if they were relevant

play15:14

and we had like 3% of leads that were

play15:16

relevant from the whole from 100% so

play15:19

let's say we

play15:21

had 2K leads

play15:24

exported so only 60 of them were

play15:27

relevant so this was very very low so I

play15:29

told them listen are you filtering the

play15:32

Apollo leads before you send them to me

play15:35

and they told me that they were not

play15:37

aware of all the filtering abilities so

play15:39

I told them okay listen let's try to

play15:42

filter first of all company side this is

play15:45

straightforward everybody knows that you

play15:47

can filter in AP poloo using headcount

play15:50

but then I told them let's

play15:53

also filter by technology so in Apollo

play15:56

you have the ability to filter based on

play15:58

the technologies that the the website is

play16:00

using and since we were targeting a

play16:04

companies that are running Facebook ads

play16:07

I told them listen let's look for

play16:09

Facebook ad pixel this is a technology

play16:11

that we can look for perhaps we can lose

play16:14

a look for um an AB test all the AB

play16:17

testing tools so

play16:19

unbounce um vwo stuff like

play16:24

this and we also added a l layer of of

play16:27

keywords

play16:29

and obviously geographies and job job

play16:33

titles Etc so this way adding more

play16:37

filters at the top of the

play16:40

process helped us in creating a smaller

play16:44

pool of prospects which were way more

play16:47

relevant and then we created we ran the

play16:51

automation again on this pool of leads

play16:54

and in opposing to 3% of qualified leads

play16:57

we got almost 30% % of qualified

play17:00

leads and this just goes to show you the

play17:03

importance of knowing different tools

play17:06

and different abil abilities of tools

play17:08

and this is why I like uh automation

play17:11

automating business processes and I'm

play17:13

always keeping an open mind because

play17:16

sometimes a small Nuance in the tool

play17:20

just a small feature in the tool can

play17:23

completely accelerate your automation

play17:25

process and make your business process

play17:27

way more efficient and

play17:30

effective so this is why it's so

play17:32

important to understand all the the

play17:35

features provided by the tool and this

play17:38

is related to what I been encountering

play17:41

with AA because I've had many challenges

play17:45

solving this uh specific Challenge B AA

play17:48

with regards to Distributing it and it's

play17:51

probably it's not doable without like a

play17:53

very big and significant work

play17:56

around Okay cool so we covered UTA and

play17:59

we covered the story about Apollos

play18:00

scraping and I also discussed the

play18:03

importance of

play18:04

documentation and this leads me to the

play18:07

last topic for today which is using

play18:09

Google app scripts and this is actually

play18:12

a realization that I finding that I had

play18:16

just a few days ago about the power of

play18:19

Google Apps scripts

play18:23

sometimes um we are looking in other

play18:26

places looking for solution but the

play18:29

solution might be under right under our

play18:31

nose and this is an example of me

play18:36

not being probably I wouldn't say not

play18:39

being curious enough but not

play18:41

understanding the whole scope of

play18:43

abilities that Google app scripts is

play18:45

providing but now I understand and it is

play18:49

really amazing and I want to share with

play18:50

you what I did just just a small

play18:54

example to pick your curiosity with

play18:56

regards to uh using Google app scripts

play18:59

and the reason why I'm sharing this with

play19:01

you because I wanted to create the

play19:03

Automation in

play19:05

automa but now I'm thinking but since I

play19:08

I realized okay this is very challenging

play19:10

with AA and you always have this dilemma

play19:13

should I um muscle through the challenge

play19:16

and try to solve this or should I leave

play19:19

this um service provider this solution

play19:22

provider and try to build the solution

play19:25

elsewhere so I thought of going back to

play19:27

Microsoft automate or maybe automating

play19:30

with selenium

play19:32

base so I just went back and forth and

play19:35

then I said okay maybe I can just build

play19:37

something with a Google Sheets and zapia

play19:40

or or Google Sheets with

play19:42

n8n and I looked up looked it up in

play19:46

YouTube and then I saw someone that just

play19:47

created an automation using Google app

play19:50

scripts and this picked my curiosity and

play19:52

this is what I build using Google app

play19:54

script so

play19:56

basically just a a small example so I

play19:59

created a

play20:00

database over here it's a Google

play20:03

spreadsheet of first name last name

play20:06

company name email and an event and what

play20:10

I wanted to do is create an automation

play20:13

that sends out

play20:16

emails to all the prospects over here so

play20:19

let's say

play20:22

Tanny deito

play20:25

whatever Chris Ronaldo

play20:30

Etc now let's

play20:43

say I'm just going to add this fast okay

play20:46

so I have all of these

play20:49

prospects and I wanted to send all of

play20:51

them an email with an attachment and

play20:54

this is very cool because you can

play20:56

actually Leverage Google app scripts to

play21:01

create an

play21:02

attachment

play21:04

dynamically so check this out what I did

play21:08

here I used GPT chat GPT to write this

play21:11

speech template and this is a a pitch

play21:15

for selling Automation Services and as

play21:18

you can see here this is a dynamic field

play21:21

de first and last

play21:23

name in today's rapidly evolving digital

play21:26

landscape staying ahead requires not

play21:27

just in but also the ability to execute

play21:29

processes with efficiency and and

play21:32

precision Etc now we have tailor

play21:36

automation solutions for company name

play21:39

and this

play21:41

is the ID of the document and what I did

play21:45

over here I went to chat GPT and I asked

play21:47

it to develop an app script for

play21:51

me so the goal to develop an a Google

play21:54

app script that automates the creation

play21:55

of personalized invitation PDFs using a

play21:58

Google Docs template the script should

play22:01

replace specific placeholders in the

play22:03

document with information from Google

play22:05

sheet spreadsheet first name last name

play22:07

and company name then email the

play22:09

customized PDF to an address listed in

play22:11

the spreadsheet requirements Google

play22:14

Sheets contains the data to personalize

play22:15

each invitation including the

play22:17

recipient's first name Google Docs a

play22:20

template for the invitation with

play22:21

placeholders and Google app scripts to

play22:24

automate steps for the script

play22:26

development

play22:28

so you can see over

play22:31

here and then you can see over here it

play22:34

wrote the script and what I

play22:37

did you can just come

play22:40

here extension up

play22:46

scripts and this is the code I just

play22:48

pasted the

play22:50

code and you save the project

play22:53

name over here I created a button so

play22:56

this is also something very nice if you

play22:59

want to sell your automation or

play23:01

internally just want to make the

play23:03

automation look better you can

play23:06

draw the

play23:08

button so

play23:15

event send event this is the other

play23:18

automation I'll show you in a

play23:21

moment save and

play23:25

close and right here you can

play23:28

assign a

play23:29

script so you assign a script basically

play23:32

you go back here you take the name of

play23:36

the function so create calendar calendar

play23:38

in events I will explain to you in a

play23:40

moment what it

play23:43

means assign script paste it and there

play23:47

you go whenever you press the button

play23:49

it's going

play23:50

to run the script so basically as I

play23:53

showed you the first script that I

play23:55

created which you can see over here

play23:58

basically takes all of these

play24:02

emails and it

play24:05

creates a document dedicated per

play24:10

recipient it updates the first name and

play24:12

last name and company name based on the

play24:16

data over here and it sends all the

play24:19

emails to everybody so you can see here

play24:21

I'm going to press the button it is

play24:24

running the

play24:26

script

play24:31

basically what it does now it is

play24:33

actually updating the

play24:35

document per customer P per recipient

play24:39

and it is also sending the the emails

play24:42

which is amazing imagine that you had

play24:44

over here like 200 uh

play24:48

rows finish script let's open

play24:56

Gmail

play25:02

you can see

play25:06

here please find attach your

play25:10

invitation Dear Chris Ronaldo in today's

play25:13

rapidly evolving digital landscape ahead

play25:15

blah blah blah you

play25:17

see T automation solution for Ronaldo

play25:20

like it took the company

play25:23

name let's go to the next one is D De

play25:26

Vito

play25:29

dear Dan deito for deito this is a

play25:32

company name this is amazing this is

play25:34

really cool so using GPT chat GPT to

play25:38

write the script and just creating the

play25:40

script now I wanted to see if I can also

play25:43

create events I wasn't

play25:46

sure if I can also add calendar events

play25:50

but fortunately I I could add the

play25:52

calendar events and it's amazing because

play25:55

all of these tools are in the Google

play25:56

Suite uh it's so easy to automate

play26:00

everything by the

play26:02

way I wanted to share with you that

play26:05

Google offers a ton of free resources

play26:08

for learning more about their um

play26:12

Solutions and tools so you can just go

play26:14

over here to Cod laabs and see different

play26:18

um lessons and tutorials very high

play26:21

quality guided tutorial that they are

play26:23

sharing regarding all of their tools you

play26:26

also have similar stuff for Google

play26:28

Google ads YouTube ads

play26:31

um just a wealth of free knowledge that

play26:34

is provided by Google so I highly

play26:36

recommend that you check it out now let

play26:38

me share with you the second script the

play26:40

second script is basically I wanted to

play26:44

create

play26:47

events based on these hours and I went

play26:51

to chat

play26:54

GPT and I asked it to create

play27:00

I will show you exactly

play27:02

what I

play27:05

did never

play27:06

mind I I went a bit back and forth with

play27:09

it because it it

play27:12

didn't didn't write the script correctly

play27:14

on the first iteration but after like

play27:17

two Corrections he did write the script

play27:19

correctly basically what I did I took

play27:22

this I copy and pasted it into CH GPT

play27:25

and I told it listen I want you to send

play27:27

to create a Google app script to send a

play27:30

calendar

play27:32

invitations to these emails based on the

play27:35

event time and then it wrote this

play27:42

script which is

play27:45

very short so basically create calendar

play27:48

events it is

play27:51

pulling the data from the

play27:55

spreadsheet it is extracting the the

play27:57

event details from each row it is

play27:59

passing the event data and time it

play28:01

calculates the end time assuming one

play28:03

hour duration for each event it creates

play28:06

the event title dynamically meeting with

play28:09

first name and last name from company

play28:12

and it creates the calendar

play28:15

event now let's see how it does

play28:20

so so let's open the

play28:23

event 5th of 5th of March

play28:30

okay so not too many events in this

play28:33

calendar but let's send the

play28:38

event boom meeting with your own Ecom X

play28:41

Factor meeting with your own bin meeting

play28:44

with

play28:48

yba yes that's

play28:50

it as you can see just added all the

play28:53

events 1 hour

play28:56

long obviously l i could have adjusted

play28:59

it making sure that it also sends the

play29:01

specific uh I don't know Zoom link

play29:05

because you can over here add the zoom

play29:07

link or location

play29:09

or more attend attendees for the event

play29:13

there is a ton of stuff that you can do

play29:15

with this but for me it was just

play29:17

mindblowing to understand the abilities

play29:19

of Google app

play29:21

scripts I think we will start wrapping

play29:23

up this video um it was kind of of a

play29:27

high level video

play29:30

regarding how I view troubleshooting

play29:32

with automations and the importance of

play29:36

understanding all the abilities of the

play29:40

tools I remember like 5 years

play29:43

ago I spoke with an automation architect

play29:46

and he told me that one of his most

play29:49

important takeaways or tips is first you

play29:53

must try to solve all the Automation in

play29:57

as little tools as

play29:59

possible so he made it a point to try to

play30:03

solve as many steps of the Automation

play30:05

natively in a tool without moving the

play30:10

without

play30:12

changing entities or moving the entities

play30:14

in different workflows in different

play30:16

solutions so if you can automate let's

play30:19

say you want to create filters or

play30:21

forward stuff so forward email so you

play30:25

just use all the functionalities that

play30:26

Gmail is already providing you can

play30:29

automate a lot of stuff natively in

play30:31

Gmail in opposing to starting to

play30:34

move to connect zier or make to Gmail

play30:38

and then connecting it with via API so

play30:41

as much as possible try to solve stuff

play30:43

in one uh SAS or one service provider

play30:48

and not expand using connectors like

play30:51

make or n8n or zapier because this

play30:55

um makes the process just just more

play30:58

complex so again this video was mostly

play31:01

focused on how I view automations and

play31:04

the

play31:05

importance like the emphasis that I'm

play31:07

putting on understanding all the

play31:09

features and abilities that the solution

play31:11

is providing before running into the

play31:14

solution and trying to solve the solve

play31:17

what I need to solve within the

play31:18

solutions because I want to move to

play31:21

remove

play31:24

inefficiencies and yes I guess that's it

play31:26

for today if you guys enjoyed the video

play31:29

please um make sure to subscribe

play31:32

obviously leave a like and a comment

play31:34

below let me know your thoughts about

play31:35

the video if you have any questions I'm

play31:37

always happy to answer if you have ideas

play31:41

for improving the video the content the

play31:43

pace the depth uh of what we covered

play31:46

please feel free to share any criticism

play31:49

I'm always welcoming criticism putting

play31:52

in the Reps and trying to create better

play31:54

content while I'm learning from this

play31:58

um and Reporting my findings to you

play32:01

guys sep of water before we end

play32:09

up yes I guess that's it until next time

play32:12

keep on

play32:16

automating

Rate This

5.0 / 5 (0 votes)

Do you need a summary in English?