How can I export a Google Sheets sheet to a single Excel file?

How To
1

Hey,

I have a Google Sheets file with multiple tabs/sheets. I need to process one of them weekly and send it to someone.

I understand that I can export the Google Sheets to Excel, but it exports the entire spreadsheet. It seems that I need to first copy the specific tab I need to a new Google Sheets file before exporting. And this is the point where I am lost. :rofl:

Anyone?

Thanks in advance!

2

Hi @andremoura,

Hi,

You can do something like this:

image
image1645×477 87.4 KB

The tricky part is the naming. If you need a dynamic name (i.e. the name must be different every time), then you can do something like this:

image
image825×569 64.2 KB

Or always use the same Google sheet. You could delete any existing sheet if you reuse the same Google Sheet. Or you could try using the same sheet name to see what happens (I didn’t test that).

Then you get the sheet you need to copy from. In my case, I selected an existing one. However, if your sheet will change every time, you’ll need to come up with an approach that woks best for you.

image
image492×894 51.7 KB

You might want to trigger your scenario by watching a folder and when the sheet appears in the folder, that’s when the scenario begins. A webhook could be an option also.

Finally, download and upload the file, making sure you enable the advanced options.

image
image493×891 49.3 KB

And I think that should do it.

Here is the blueprint in case you want to use it as a starting point. You’ll need to fix the connections and the folder/file IDs.

blueprint-2024-08-02.json (18.8 KB)

L

3 Likes
3

I will try it. Thanks.

4

hey @L_Duperval

It worked. Thanks.

About the trigger, I will use a day and time of the week to run it weekly.

Also, I will try to solve two things that I didn’t like: it generates one new Google Sheets and one new Excel XLS per run. If I use a static name it creates multiple sheets with the same name.

1 Like
5

I’m happy it worked.

For the triggger, you can set your scenario to run weekly in hte settings. I’m sure you know that already, but just in case.

I didn’t know if you were using new file every time, which is why I created a new file with every run.

For the named sheets, maybe you can check to see if there is a sheet and if so, delete everrything in there and put the new content there.

L