Linking Sheets with Docs in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a monthly sales report in Google Docs that automatically updates when sales data changes in Google Sheets.

📊 Data: You have a Google Sheet with monthly sales data by product and region.

🎯 Deliverable: Create a Google Doc report that links to the sales data in Google Sheets and updates automatically when the sheet changes.

Sample Data

Month	Region	Product	Sales
January	North	Widget A	1200
January	South	Widget B	900
February	North	Widget A	1500
February	South	Widget B	1100
March	North	Widget A	1300
March	South	Widget B	1000

1

Step 1: Open your Google Sheet with the sales data and select the range A1:D7 that contains the data including headers.

No formula needed.

Expected Result

The data range is selected and ready to be linked.

2

Step 2: Copy the selected range (Ctrl+C or Cmd+C).

No formula needed.

Expected Result

The sales data range is copied to the clipboard.

3

Step 3: Open a new or existing Google Doc where you want the sales report.

No formula needed.

Expected Result

Google Doc is open and ready to receive data.

4

Step 4: Paste the copied data into the Google Doc using Edit > Paste or Ctrl+V (Cmd+V).

No formula needed.

Expected Result

A dialog appears asking if you want to link the table to the spreadsheet.

5

Step 5: In the dialog, choose 'Link to spreadsheet' and click 'Paste'.

No formula needed.

Expected Result

The sales data table appears in the Google Doc and is linked to the Google Sheet.

6

Step 6: To update the data in the Google Doc after changes in the Sheet, click the 'Update' button above the table in the Doc.

No formula needed.

Expected Result

The table in the Google Doc updates to reflect the latest sales data from the Sheet.

Final Result

Google Doc Sales Report

+---------+--------+----------+-------+
| Month   | Region | Product  | Sales |
+---------+--------+----------+-------+
| January | North  | Widget A | 1200  |
| January | South  | Widget B | 900   |
| February| North  | Widget A | 1500  |
| February| South  | Widget B | 1100  |
| March   | North  | Widget A | 1300  |
| March   | South  | Widget B | 1000  |
+---------+--------+----------+-------+

[Linked to Google Sheet - Click 'Update' to refresh]

✓The sales report in Google Docs is linked to the Google Sheet data.

✓Any updates in the Sheet can be reflected in the Doc by clicking 'Update'.

✓This saves time and ensures the report always shows current sales data.

Bonus Challenge

Create a summary table in the Google Sheet that shows total sales by month, then link that summary table to the Google Doc for a concise report.

Show Hint

Use the SUMIF formula in Google Sheets to calculate total sales per month, then copy and link that summary range to the Doc.