Need help in importing a CSV file data from Gmail attachment to an existing Google sheet

[Nijo George]

Hi Everyone,

I am new in this group, and I don't have any experience in apps scripts. 

I am here asking for some help to develop a script which can import data from CSV file in Gmail attachment. I have to develop a report on daily basis using this imported data from the CSV file. Following are the scenarios.

• The CSV files are automatically generated and received to my Gmail inbox on a scheduled time. Those emails can be identified by "sender email id" and "subject". Only one csv file attachment will be there in each mail. The CSV attachments are having same file name but are sent as separate email with separate subjects.
• I want to import these csv attachments into an existing Gsheet. Based on mail subject, each csv data should replace the entire contents of the existing sheets of this Gsheet.

I searched web and even in this group for the script but was not successful. I am posting a script which I got from the web. But it's not working.

function extractCSVFromGmailAndImport() {

  var label = "Report Data"; // Replace with your desired label

  var subjects = ["Data 1", "Data 2", "Data 3"]; // Replace with your desired subjects

  var spreadsheetId = "12345678900987654311"; // Replace with your Google Sheets file ID

  // Import CSV data into each sheet

  for (var i = 0; i < subjects.length; i++) {

    var subject = subjects[i];

    var sheetName = subject;

    var sheet = SpreadsheetApp.openById(spreadsheetId).getSheetByName(sheetName);

    // Clear existing data in the sheet

    sheet.clear();

    // Get the Gmail label

    var threads = GmailApp.search('label:' + label + ' subject:' + subject);

    // Retrieve the CSV attachment from the email

    for (var j = 0; j < threads.length; j++) {

      var thread = threads[j];

      var messages = thread.getMessages();

      for (var k = 0; k < messages.length; k++) {

        var message = messages[k];

        var attachments = message.getAttachmentsByType('application/csv');

        if (attachments.length > 0) {

          var attachment = attachments[0];

          var csvData = Utilities.newBlob(attachment.getDataAsString()).getDataAsString();

          var csv = Utilities.parseCsv(csvData);

          sheet.getRange(sheet.getLastRow() + 1, 1, csv.length, csv[0].length).setValues(csv);

        }

      }

    }

  }

}

While running this script I am getting error as follows

Error
TypeError: message.getAttachmentsByType is not a function
extractCSVFromGmailAndImport @ Code.gs:25

Kindly help me in this script.