I would like you to create a tool (script, etc.) that can take specific sections of an email and populate the information into a spreadsheet.
*Ideally, I'd like this to be a Google Doc spreadsheet if possible.
(1) The email we receive has about 30 entries, all of which are in the same format
(2) We need to gather specific info from each entry and put it into a spreadsheet cell. Note that we only need to do this in the GUEST POSTS NEEDED section, not the other sections.
I've attached the full email as a PDF as well as a screenshot of the specific sections we would want to gather into a spreadsheet (each piece of information is highlighted a different color, which would need to be in a different cell of the spreadsheet).
When replying, explain approximately how you plan on doing this and the cost to complete it. I would estimate not a large amount of money since it can probably be done somehow in Google Docs, maybe by creating an RSS feed of the email and then parsing the info from that RSS feed into the Google Doc. I'm fairly technical, but don't have the time to build this.
Looking fwd to your response
Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.