Insert new row in google sheet with data from a new google sheet uploaded to google drive

[chris@goroofitright]

I want to use the Google Drive "New File in Specific Folder" trigger. This will retrieve a new google sheet that was uploaded to that folder. Then I need to take data from specific cells in that google sheet and insert that data into a new row in an already existing google sheet. I cannot figure out how to do this. Specifically I am having trouble accessing the data and mapping it. Can you please help me?

 

[Pabblymember11]

Hey @chris@goroofitright

Can you please share the workflow URL in which you have tried the same?

 

[chris@goroofitright]

Sure thing!

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[ArshilAhmad]

Based on my limited understanding of your use case, it seems like you want to fetch the data from the spreadsheet you uploaded in a specific folder on your Google Drive. If that is the case, you can use the 'Google Sheets: Get Row(s)' action event to retrieve the data from that particular Google Sheets spreadsheet. Be sure to enable the mapping option and map the spreadsheet ID from the trigger step.

Please watch the video shared below to understand how you can use Get Row(s) action event. Ignore the other trigger and action steps.

 

[chris@goroofitright]

Thank you for your response. That was definitely something I didn't realize I needed to do. However, I cannot map the sheet name. I tried manually entering it, but that did not work either.

 

[ArshilAhmad]

Please ensure that the spreadsheet you are trying to capture data from has headers for each column.

 

[chris@goroofitright]

Thanks! That fixed it.