Automatically adding new google sheets to looker studio

[Priyanka1311]

Hello all

I would like to create a looker studio dashboard from data stored in google sheets. The challenge is that each week a new spreadsheet is created. Is there a way to automatically add the newly created google sheet to looker studio data source? I don't want to manually add the new sheets each week.

Look forward to hearing your th

[lauratilton]

Is the weekly data just for that week, and you're looking to combine 52 weekly sheets per year? Or does each weekly sheet have all the data for the year so far, so you just want to use the new one each week?

[Priyanka1311]

Hello, you are right - each spreadsheet contains one week of data and I am looking to combine each week as data is generated for newer weeks

[xaoc]

same question, need answer

[lauratilton]

The easiest thing I can think of is that you could set up a master Sheet that uses IMPORTRANGE to combine multiple sheets together, like this:

={IMPORTRANGE(sheet, range);IMPORTRANGE(sheet, range)...}

and use the master Sheet as the source for your report. Then each week, you'd just add the new sheet information to your master Sheet's IMPORTRANGE formula. Although this isn't automated, at least this way you don't have to touch Looker Studio, just the master Sheet.

I think there are some add-ons for Sheets that may be able to help with this, or I'm sure scripting could be helpful with the automation but I haven't tried either of these approaches.