Short answer: Use a free Google Apps Script that builds a Master tab from all your tabs, with a Source column showing where every row came from. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Check your tabs; Paste the script; Run mergeAll; Run it again when things change; Add a refresh button.
How to set it up
- Check your tabs. Start with a tab for each store, month or salesperson, all with the same columns.
- Paste the script. Open Extensions, then Apps Script, and paste in the code below. To pull in other spreadsheets as well, paste their IDs into the list at the top.
- Run mergeAll. The first time it runs, Google asks for permission because the script works in your own account. Review it and allow it; that only happens once. The Master tab now has every row, plus a Source column with the tab or file it came from.
- Run it again when things change. It rebuilds the Master tab from scratch each time, so there are no duplicates.
- Add a refresh button. Insert a drawing on the Master tab, click its three dots, choose Assign script and type
mergeAll. Anyone can then refresh it with one click.
Want this set up for your business? Free written scope in 20 minutes
Get the script
Download it free
We'll email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Ready-made copy
A Google Sheet with the tabs and the script already in place: click Make a copy and it works.
$19 one-time, emailed straight after payment.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
$49 one-time.
Questions
What does this script do?
It is a free Google Apps Script that builds a Master tab from all your tabs, with a Source column showing where every row came from.
How do I set it up?
In 5 steps: 1. Check your tabs; 2. Paste the script; 3. Run mergeAll; 4. Run it again when things change; 5. Add a refresh button. The full steps are on this page.
Is it free, and does it send my data anywhere?
It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Can you install it for me?
Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
Want this connected to the rest of your tools? Send us a short brief.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/