Mark on your existing reports to merge with data summary or data value from any Google sheets/docs/web data tables. No more restrictions on how you format your reports.
Listing updated:September 15, 2023
Works with:
This add-on automates your existing Google Sheet ™ reports to pull data from Google sheet/doc/web data tables which have data name on first row and data values below. You simply mark once on your reports where to get, filter, list, count, sum or copy from the data tables. Report runner will pull and track the update for you. You can also export the report without markers.

How to install?

Go to Google Marketplace to install. After Installation, your sheet menu Extensions will have this add-on . If not, please re-open your sheet.

How to use?

1. Open your data sheet. From this add-on menu, select Show spreadsheet ID and copy the ID to clipboard. For Google doc, copy the ID from URL. For web, copy the URL.
2. Open your report sheet. For report table, highlight the columns that you want this add-on to pull in data from your data sheet. For data cell, highlight the cell.
3. Open this add-on menu, select Open marker sidebar and pick the marker for list, label, count, sum, copy, or tag.
4. Enter the marker details.
5. To run your report, open this add-on menu and select Run report . A log sheet MRR Log will display the running status.
6. To export your report, open this add-on menu and select Export report. A copy without markers will be copied to your Google drive root directory (defaulted by Google).
7. To test a new marker, open this add-on menu and select Select markers for test run. On the displayed sheet MRR Log, tick the markers. Open this add-on menu and select Run report to test run.
8. To reset the data update tracking, open this add-on menu and select Reset data update tracking. The tracking notes will be reset to blank.

This add-on is free. Its use of data received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements.

Your donation is appreciated to sustain and enhance it in Google Marketplace for your usage.

2023-06-01 support pulling date from web table.
2023-02-06 support pulling data from the nth table in Google Doc. 
2023-01-16 support pulling data from Google Doc.
Additional information
PricingFree of charge with paid features
Privacy policy
Terms of service
Extract & Paste Data (MRR) will ask for the permissions shown below. Learn more
Extract & Paste Data (MRR) will need access to your Google account
This will allow Extract & Paste Data (MRR) to :
See all your Google Docs documents
View and manage spreadsheets that this application has been installed in
See all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Wing Lee
March 22, 2023
We have multiple departments maintaining their bi-monthly rosters in Google sheet or Google doc. I am using it to pull names from the rosters for a given date into a single sheet which is easy to use and check.
Is this review helpful?
1-1 of 1
Clear search
Close search
Google apps
Main menu