Upload Excel sheet to Google Sheet

Questions
1

Hi everyone, I would like to know if anyone has found a way to convert an excel sheet to a Google sheet. I would really appreciate it, if someone can put me through this

2

You can read the xlsx, extract rows from it and then write to Google Sheets:

Is that what you were looking for?

1 Like
3

Thanks for your Help Jabbson. I am not sure if this fixes it, as it is not outputting any data at the Read XLSX node when i try this, here is my full workflow. Thanks

4

image
image2538×1216 274 KB

5

I had this xlsx file on my n8n server in /data/shared/n8n.xlsx, do you?

6

No, I don’t

7

Well, that would be why there is no output then. I had a file on the disk, if you have it as an attachment, you don’t need to read if from the disk.

8

Thanks, it is now working. I am wondering, if there is a way to achieve the same structure as the Excel file. Also, do you know if it would be possible to create a new spreadsheet instead of updating an existing one

9

image
image2547×1142 50.4 KB

This is the Original Excel sheet, and below is the sheet been updated

image
image2554×1068 37.4 KB

10

Quick question, you know you can just put the xlsx to google drive and have it converted to Sheets, right?

11

I tried that, but it’s not working

12

Well, if Google can’t do it, I am not sure we can :slight_smile:

1 Like
13

Ohh, Thanks Jabbson

14

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