![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Google Apps Script (Javascript) to help automate a Google Sheet
- or -
Post a project like this531
£210(approx. $270)
- Posted:
- Proposals: 9
- Remote
- #3810002
- OPPORTUNITY
- Awarded
PPH Top Rated Digital Marketer (Social Media Ads, Google Ads, SEO, Social Media Management, YouTube expert)
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
36848473809051649971198242750415918509540762149112644637103441
![Zoltan L.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/885235b33ff7f9287fd60b3c07907461_70x70.jpg)
![Jahan K.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/bd8c46c71dc55e339285e3662af12e8a_70x70.gif)
![Abz T.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/c75add1f54c542d7af00eca0bba7545f_70x70.jpeg)
![Mahmood U.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/1f8949a2fbd45d4f6ed63b7070fe8961_70x70.png)
![Yassine A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/01a89b2f4c077b48924a737f650ced4e_70x70.jpg)
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
I've developed a Google Sheet that scrapes website content and sends it to GPT-3 to rewrite it as new content.
I would like you to use that sheet as a template to make a new sheet that does something similar. Most of the functions you need are already there. The new sheet will automate blogger outreach.
The new sheet will:
Scrape Google or Bing search results for sites with blogs
Then it will check those sites to see if the blog posts contain links to external sites (to see if it is suitable for blogger outreach)
Then it will try and find a contact email address on the site
The ask GPT-3 to draft an email to that email address
Then use the mail function to send the email.
The sheet you will be starting with already has functions to scrape content and to make calls to GPT-3. I'd like to use these existing functions as much as possible.
I'm looking for a quick turnaround on this please, otherwise I would code it myself.
Here's an old version of the sheet I made to rewrite articles, to give you an idea of the functions and how the sheet will work https://docs.google.com/spreadsheets/d/1p926RmcNqg_Y26KewU68K1nAs4gVEsKB_pLl5w6_hgM/
I would like you to use that sheet as a template to make a new sheet that does something similar. Most of the functions you need are already there. The new sheet will automate blogger outreach.
The new sheet will:
Scrape Google or Bing search results for sites with blogs
Then it will check those sites to see if the blog posts contain links to external sites (to see if it is suitable for blogger outreach)
Then it will try and find a contact email address on the site
The ask GPT-3 to draft an email to that email address
Then use the mail function to send the email.
The sheet you will be starting with already has functions to scrape content and to make calls to GPT-3. I'd like to use these existing functions as much as possible.
I'm looking for a quick turnaround on this please, otherwise I would code it myself.
Here's an old version of the sheet I made to rewrite articles, to give you an idea of the functions and how the sheet will work https://docs.google.com/spreadsheets/d/1p926RmcNqg_Y26KewU68K1nAs4gVEsKB_pLl5w6_hgM/
![Measured Marketing](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/d4df1659216e46c2bb902b9960e8c7c7_150x150.jpeg)
Measured Marketing
100% (4)Projects Completed
4
Freelancers worked with
4
Projects awarded
60%
Last project
21 Jan 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi,
When do you want to complete this work?
1045859
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies