Draft documents and build data analysis tables with AI in Google Docs and Sheets

Prompt for Generating Drafts Based on Existing Files

Prompt for Searching Information & Building Tables

Generating Document Drafts with Gemini in Google Docs

1. Open a new Google Docs document.
2. Click the 'Help me write' button or the 'Generate a doc' box that appears at the top of the document canvas.
3. Type your prompt in the provided input box.
4. Use the '@' (at-mention) symbol to reference specific files from your Google Drive to provide context to the AI.
5. Click the 'Create' button to automatically generate the draft.
6. Use the 'Ask Gemini' panel on the right to make further adjustments, such as selecting the 'Match doc format' option to align the writing style.

Building Automated Data Tables in Google Sheets

1. Open a new Google Sheets file.
2. Click the 'Ask Gemini' icon in the top right corner to open the AI side panel.
3. Enter a prompt in the chat box specifying the data you want to collect.
4. Ensure your prompt instructs Gemini to search for information from specific sources such as Google Drive, Gmail, or web search.
5. Wait for Gemini to process the information and generate a table directly into your spreadsheet.
6. Use the 'Fill with Gemini' feature to automatically complete empty data based on existing data patterns.