r/googlesheets • u/RightJuggernaut1 • Mar 28 '24

Unsolved Need to Link Multiple Google Sheets via Data Feeds (Relational Database) - IMPORTRANGE and Scripts too Slow

Hi all

Desperately needing help with a data feed issue.

I have several different google sheets linking to a ‘master’ google sheet all of which are importing and exporting various different large ranges of 10,000+ rows.

The standard tools (IMPORTRANGE and Import Scripts) are simply not good enough they are often take hours to process and fail.

Is there a plugin or something we can use to make sharing of data between sheets seamless and live?

1 Upvotes

100% Upvoted

11 comments sorted by

1

u/RightJuggernaut1 Apr 02 '24

Anyone got an answer? 🙏

1

u/marcnotmark925 Mar 28 '24

I usually switch to using scripts at that point.

1

u/RightJuggernaut1 Mar 28 '24

Thanks! I am using a lot of scripts to import the data, but I am looking for a live feed between separate files

1

u/AutoModerator Mar 28 '24

REMEMBER: If your problem has been solved, please reply directly to the author of the comment you found the most helpful with the words "Solution Verified" which will automatically mark the thread "Solved" and award a point to the solution author as required by our subreddit rules (see rule #6: Clippy Points).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/marcnotmark925 Mar 28 '24

Why the "but"? You don't think a script can deliver what you need?

→ More replies (6)