How can I merge google files into one file?

KNIME Analytics Platform
1

Hi,

I have 10 Google Sheets files with the same parameters and tabs. I would like to consolidate the data from each file into one new Google Sheet file. However, I’m not sure what steps to take next.

I tried following some instructions I found online, but I never got to the point where I could choose the tab I want to copy. Could you please guide me through the process?

Thank you!

knime flow
knime flow1506×695 55.4 KB

2

Hi @ellenfeliciano,

welcome to the Knime Community. The process would, roughly speaking, include:

  1. Define Spreadsheet URLs using Table Creator Node
  2. Use Row to Variable Loop to iterate over each row by reading each file and have the loop end node collect the data
  3. Write, using the Google Sheets Writer Node, the concatenated data into a new sheet of your choice

Best
Mike

2 Likes
3

Where? How do I connect these nodes?

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.