How to use the data from a new file, in the existing workflow?

[Ruben_Klein]

Hey dear community,

I’m trying to get something done along the lines of:

1. A new google sheet is filled out with data for every new client
2. That new sheet is then added to a Drive Folder that is being watched by my Make scenario
3. Then a google sheets module takes the data from inside that newly added sheet on the folder
4. And “Add a Row” to “master spreadsheet”

This will feed into another automation that is watching this master spreadsheet, in order to generate data. But this first spreadsheet on this unique format is presenting some challenges.

This is the Sheet we want to add to the Folder, and have the "Answers"column extracted to be used

This is the row we want to add the extracted data

The issue I have with this process, is that we can’t use the same spreadsheet and just add more content. Every new client has a new spreadsheet. So we need a way to have this automation get the data from every new file added into a Drive Folder, extracted and appended to a master spreadsheet.

Is it possible? Which modules should I use?

Here’s what I’ve been trying so far:

Any help is welcome!! Thanks guys!

[Mourad_Himmi]

Here is the process as i understand it : * Trigger: New file added to Drive folder

• Action 1: Open Google Sheets

  • Sheet ID: Get the ID of the new client sheet from the Drive folder
  • Function: Get Column
    • Column Index: 2 (assuming “Answers” is the second column)
    • Function: Get Values

• Action 2: Open Google Sheets

  • Sheet ID: ID of the master spreadsheet
  • Function: Add Row
    • Row Data: The extracted data from the “Answers” column

Try using get column instead of “get range value”

[Ruben_Klein]

Thanks Mourad, I will try that out!