How To Send Google Doc Text to Google Sheets

How to Send Google Doc Text to Google Sheets Update a Google Sheet Cell from a Google Doc with Apps Script (Custom Menu + onOpen) The video shows how to use Google Apps Script to copy all text from a Google Doc into a specific Google Sheets cell (A1 on a tab named "doc"). It walks through creating a custom spreadsheet menu using the built-in onOpen() function (SpreadsheetApp.getUi(), createMenu(), addItem(), addToUi()) so a user can manually trigger the update. It then builds an updateGoogleSheet() function that gets the target sheet and tab (SpreadsheetApp.openByUrl(), getSheetByName()), reads the Google Doc’s body text (DocumentApp.getActiveDocument().getBody().getText()), and writes it into A1 using getRange(1,1).setValue(), including preserving new lines. The script also demonstrates testing the menu item with a UI alert and notes the one-time authorization prompt on first run. 00:00 Goal: Update a Google Sheet cell from a Google Doc (Automation Overview) 00:32 Build a Custom Menu with onOpen in Apps Script 02:07 Test the Menu Action (UI Alert) to Confirm It Works 02:41 Write the Update Function: Target Sheet, Tab, and Cell Range 04:00 Pull Text from the Google Doc Body and Set the Cell Value 04:25 Run It + Authorization: Verify the Sheet Updates (New Lines Included) 05:02 Wrap-Up, What You Learned, and Subscribe/Next Videos