Best way to "bring in" data from other spreadsheets

Ask for Help
1

I am building an event app. I originally only intended to use the multiple tabs on one google sheet. However, presenters have their own sheets with info I would like to show. What is the best way to use multiple sheets in one app?

2

You could use an IMPORTRANGE formula to create new tabs in your main Sheet that would pull in data from the others’ sheets into their own tabs of your main Sheet. Either that, or provide access to your sheet through the Sharing options in Google Sheets and the others can make their own tabs directly from your main sheet.

3

I am not sure that would be dynamic. Wouldn’t that just be a snapshot of the data at the time it was taken?

4

An IMPORTRANGE should update itself automatically when used. I don’t know what the delay would be when it’s used in conjunction with a Glide app, but it shouldn’t be any more significant than the usual Google Sheets delay.

5

Thanks. I’ll try that and report back.

6

I was just researching the same and came across this…

7

IMPORTRANGE works quite well when your source data has a fixed set of columns that don’t/wont change. If that’s not the case, then it’s risky and subject to breakage.

I use IMPORTRANGE generally only when the source sheets are under my control and so I can guarantee there won’t be any nasty surprises.

For anything else (ie. “untrusted” data sources) I find it safer to write import scripts with appropriate exception handling.

8

It did do what I needed it to do.

Thank you.

1 Like
9

Yeah, it would be easier to find but I’m a no name contributor :slight_smile:

10

Nah you just changed your icon one too many :stuck_out_tongue_winking_eye:

1 Like
11

lol, the demotion from community expert didn’t help either, lmao.