Next time you refresh your sheet, you’ll see a new menu item at the top and you can run the script from that menu. In order to make calling the script easier, you can either schedule the script to run on a defined frequency from the Script Editor, or you can add this code at the end to create a custom menu. By either downloading the CSV file and manually importing it, or by automating the WordPress CSV importer to download a fresh copy of the google sheets CSV.

Your target email has to be the only or latest email in the search criteria I have the script set up to perform a search to identify the email.

The script will only retrieve a CSV file from one email.Sheet.getRange(1, 1, csvData.length, csvData.length).setValues(csvData) Sheet.clearContents().clearFormats() // clears target sheet Var csvData = Utilities.parseCsv(attachment.getDataAsString(), ',') Var sheet = SpreadsheetApp.getActiveSheet() // runs in the current active sheet Var attachment = message.getAttachments() For opening this type of files, you can use Google Sheets. Var threads = arch('CSV') // enter search criteria here CSV files are used in the Back Office for exporting reports, importing-exporting items, and clients.

How to upload csv to google sheets