I am not able to upload data from the recenlty downloaded file in google drive and automatically paste it into a new spreadsheet
Hello @Naman1 and welcome to the Make Community!
Do you have an overall description of what you’re trying to achieve here?
You’re trying to get a file from Google Drive, extract the data, then move the data into a Google Sheet? What type of file is in Google Drive?
Hi @Donald_Mitchell Thanks for the revert.
Your description about the goal is correct.
Here’s the flow-
When an attachment with .xlxs lands in gmail, the attachment is Uploaded in google drive
From Google drive the data in the excel file needs to be uploaded to a specific spreedsheet.
1 Like
Where does Make fit in to all of this, it needs to monitor the emails coming in and act on specific ones?
Here’s a flow that might help get you started
Gmail (1) will watch for new emails →
Upon new email, Iterate attachments (6) →
Filter through only attachments with .XLS in the filename →
Upload file to Google Drive as a Google Spreadsheet file (3) →
after upload list the Sheets in the Spreadsheet (7) →
For each sheet found, search rows (5)
From there, you can deal with the data and upload it to the other sheet.
In Google Drive Upload a File, there an advanced option you need
In Google Sheets List Sheets, you map in the File ID that is produced by Google Drive Upload a File
In Google Sheets Search Rows you map in the File ID from Google Drive and the Title from Google Sheets List Sheets
Speadsheet ID also exists in Google Sheets List Sheets so you could use the spreadsheet ID from that module instead of Google Drive if you want. The point is you need to use Spreadsheet ID instead of selecting the spreadsheet because you can’t select a spreadsheet that doesn’t exist, since it won’t exist until after you’ve uploaded it.
Hope that makes sense, and hope it helps!
Hi Donald,
Thanks for this, really appreciate it.
I have created this workflow, but how do I take only specific date ( Column A , Row 1-100 ) and paste it into a specific column in my master sheet ?
Master sheet is where all the data should flow from all the attachments we are getting.
Thanks in advance.
Did you mean specific data or date value in a column?
I don’t know how either of your spreadsheets are laid out so I can’t be too specific here, but I’ll try.
If you need an entire column then try using that column letter in the filter, like column A exists
If you need a specific date, then change “Basic operators: Exists” to a date filter instead.
This will produce bundles, each bundle representing a row of data.
If you’re writing a collection of rows into a Google Sheet, use an Array Aggregator followed by Google Sheets Bulk Add Rows (Advanced).
In the Array Aggregator, your Source is Google Sheets Search Rows, your Target Structure Type is “Rows” under Google Sheets Bulk Add Rows (Advanced) section, and your Rows Values should be (I think) an array of fields that make up the row of data from the Search Rows bundle.
Something like this:
