Automation process

techbeastzz

BANNED
Joined
Jun 11, 2023
Messages
259
Reaction score
101
So please try to understand me, there is a website where i just need to copy paste and send a single email and what I want to do is create a automated process where i will copy paste a single email in Google sheets tab then it copy paste automatically on that website section and start sending email right away automatically. Here's the section:
 

Attachments

  • Screenshot_20231003-144252-144.png
    Screenshot_20231003-144252-144.png
    114.6 KB · Views: 82
java scripting + chatgpt
 
looks like the website is just trying to build a email database
but any how try reverse engineering and make a unofficial API check the network see what kind of request they are sending
once you have that done let chatGPT help you with a simple python script to send http request
with the desired data getting loaded through the email and the name through a text file or excel file into a variable and make a loop


do it a right and you can send few thousand emails invite per day
 
i use jitbit. you can get the license key on youtube. I don't know how to code either. I just learned it from trial and error.

you can have it open the GSheet copy the first cell, click the down arrow, have the macro paste the text where ever you need it to, and repeat.

Like i said not to savvy with that techy stuff cuz there is a way to automate that Gsheet aspect of thr process. But that what i do.
 
Hi Mate, that´s how I would do it:

  1. Prepare email data in Google Sheets.
  2. Create a Google Apps Script in Google Sheets to interact with the website.
  3. Use the script to access the website, paste the email content, and trigger email sending. (I have no further info´s so I cannot go into details here)
  4. Set up a trigger to run the script automatically.
As @Nikolaos @ninomino19 @YesSir532 Said - it is a bit of code with Java.

BEsts
PeterFox
 
i use jitbit. you can get the license key on youtube. I don't know how to code either. I just learned it from trial and error.

you can have it open the GSheet copy the first cell, click the down arrow, have the macro paste the text where ever you need it to, and repeat.

Like i said not to savvy with that techy stuff cuz there is a way to automate that Gsheet aspect of thr process. But that what i do.
So it will work like this: like let's say again I have 100 emails with names in gsheets and it will copy and paste to another website in send email section like the image that i shown above and it will repeat until it complete sending, so it will work in jitbit or not.

(Sry for my bad English)
 
I imagine that most users mean Javascript when they say Java. Javascript and Java are two different programming languages. What you want to do can be done in any programming language that has libraries for browser automation (Java, C#, C++, Python...) or Javascript, a language created to run in web browsers.
If you don't know how to program, try BAS (Browser Automation Studio) or Selenium IDE (browser extension)
 
If you want to hire a freelancer to automate that, I can do it for you
 
So it will work like this: like let's say again I have 100 emails with names in gsheets and it will copy and paste to another website in send email section like the image that i shown above and it will repeat until it complete sending, so it will work in jitbit or not.

(Sry for my bad English)
Sorry i didn't see you reply. As I've said, I'm not very good at automation and I know there are better and easier ways to get this done, but to your question, I created this short video of what it looks like when its done. Sorry its short, sorry theres no audio or background music. I don't like to speak on recording.

Here you go, visit my link and you'll see my recording.. I'll be removing it in a day or so.
https://drive.google.com/file/d/15YTAIsSXZVeAG0qD5RbdXm0AWh3EDuH-/view?usp=sharing
 
Back
Top