Need someone to write a google apps script in google sheets to take contents from 2 different format email (6 emails per day) and put these into one spreadsheet per day in a consistent data format (matching columns and rows to header titles). We are familiar with placing the triggers in Sheets for a Script but need google script code to take contents of email and order into a specific format. Trigger will run multiple times per day to update file with any new emails received in course of day. Mapping of headers and content can be provided on commencement of project.
- Turn the body content of two different format emails (numerous emails per day) into one daily spreadsheet under one format. Emails are received through the day so triggers at different points in the day to update the daily file.
- Google spreadsheet in a specific format
- CSV export of specific cells in a prescribed format (below format) in a CSV file) .CSV (comma delimited) format