Gsheet script to get urls out of PPH search notifications in gmail
- or -
Post a project like this2064
$50
- Posted:
- Proposals: 3
- Remote
- #2093039
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Hi are you available today now for a fixed price of $50 about a job that might benefit you too?
I need to get a script cleaned-up/fixed/made to pull urls|links from a gmail message out of the search notification service that PeoplePerHour.
Probably just like you I have PPH job searches that notify my so i get messages like: "Paul X new jobs match your search results" . After awhile this turns into alot of noise to sift through. I've already setup a search query to collect those messages. For the rest i've started coding a script and collecting example scripts but ran into several stumbling blocks like trying to use the XMLservice and other errors.
I can provide my current files if you think they will be useful but they are a MESS as i've been trying different approaches and might just be useless to you as an expert.
The 1st phase script basically does:
Get messages from gmail using a search query <- working
Get date of message(messageDate)
Get the urls(originalURL) from each mail message PPH lists for postings
For each url clean|remove|urldecode mailer service parts (cleanURL) so it's the final destination url of the PPH posting see footnote [2] vs footnote [1].
Puts messageDate, cleanURL,originalURL into the active spreadsheet in 3 seperate columns in order is messageDate, cleanURL,originalURL.
originalURL
Prerequisites: For testing purposes if you never used PPH's search notifications you may want to set one or two search notifications so you can receive examples while making this script. Not sure how fast they'd send them out so i may have to give a sample message that i'll have to sanitize first /shrug.
[1] http://mailtrack.peopleperhour.com/CL0/http:%2F%2Fwww.peopleperhour.com%2Ffreelance-jobs%2Fweb-development%2Fe-commerce%2Fwant-an-e-commerce-site-in-wordpress-2091186%3Futm_source=Jobs%252BSaved%252BSearches%26utm_medium=email%26utm_campaign=Saved%252BSearches%26ref=email%23send-proposal/1/01000164ed3c721d-a9db06f3-29d3-4e97-91b3-ead75d0ef1d2-000000/k0-jih2PesNuikZTy6TB7Y2gvThcal2LNzY_EOz6nPM=47
[2] https://www.peopleperhour.com/freelance-jobs/web-development/e-commerce/want-an-e-commerce-site-in-wordpress-2091186
[3] originalURL The links in the message body have urlencoded parts, and also need to be sanitized from PPH's mailer encapsulation. The message url starts like "http://mailtrack.peopleperhour.com/CL0/http:%2F%2Fwww.peopleper...."
at the end i've included a full example url
I need to get a script cleaned-up/fixed/made to pull urls|links from a gmail message out of the search notification service that PeoplePerHour.
Probably just like you I have PPH job searches that notify my so i get messages like: "Paul X new jobs match your search results" . After awhile this turns into alot of noise to sift through. I've already setup a search query to collect those messages. For the rest i've started coding a script and collecting example scripts but ran into several stumbling blocks like trying to use the XMLservice and other errors.
I can provide my current files if you think they will be useful but they are a MESS as i've been trying different approaches and might just be useless to you as an expert.
The 1st phase script basically does:
Get messages from gmail using a search query <- working
Get date of message(messageDate)
Get the urls(originalURL) from each mail message PPH lists for postings
For each url clean|remove|urldecode mailer service parts (cleanURL) so it's the final destination url of the PPH posting see footnote [2] vs footnote [1].
Puts messageDate, cleanURL,originalURL into the active spreadsheet in 3 seperate columns in order is messageDate, cleanURL,originalURL.
originalURL
Prerequisites: For testing purposes if you never used PPH's search notifications you may want to set one or two search notifications so you can receive examples while making this script. Not sure how fast they'd send them out so i may have to give a sample message that i'll have to sanitize first /shrug.
[1] http://mailtrack.peopleperhour.com/CL0/http:%2F%2Fwww.peopleperhour.com%2Ffreelance-jobs%2Fweb-development%2Fe-commerce%2Fwant-an-e-commerce-site-in-wordpress-2091186%3Futm_source=Jobs%252BSaved%252BSearches%26utm_medium=email%26utm_campaign=Saved%252BSearches%26ref=email%23send-proposal/1/01000164ed3c721d-a9db06f3-29d3-4e97-91b3-ead75d0ef1d2-000000/k0-jih2PesNuikZTy6TB7Y2gvThcal2LNzY_EOz6nPM=47
[2] https://www.peopleperhour.com/freelance-jobs/web-development/e-commerce/want-an-e-commerce-site-in-wordpress-2091186
[3] originalURL The links in the message body have urlencoded parts, and also need to be sanitized from PPH's mailer encapsulation. The message url starts like "http://mailtrack.peopleperhour.com/CL0/http:%2F%2Fwww.peopleper...."
at the end i've included a full example url
Paul N.
100% (4)Projects Completed
3
Freelancers worked with
3
Projects awarded
50%
Last project
27 Oct 2018
Puerto Rico
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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