The Scenario
The board meeting is Tuesday. Your CFO just forwarded an email asking for the P&L summary "in PDF format, formatted, not a raw spreadsheet." You've been staring at the 'P&L Summary' tab for twenty minutes. The data is clean. The structure makes sense. But getting it into a PDF that doesn't look like it was exported from a 2009 accounting system requires building an HTML template, calling a PDF API, and doing something with the file URL — none of which is in your job description.
The bad version:
- Copy the table out of the sheet, paste it into Google Docs, spend 40 minutes reformatting the header row, the alternating colors, and the totals row that keeps splitting across pages.
- Export as PDF, email to the CFO. She replies: "Can you add a subtitle and make the negative numbers red?" Repeat.
- Save the Google Doc alongside the sheet as a second source of truth that immediately starts drifting from the data.
The real cost isn't the 40 minutes. It's that you're now the person who manually maintains a formatted document that reflects a spreadsheet — which means every data update requires two updates.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data, understands the structure, and through its DocRaptor integration it can generate a styled PDF and hand you the download URL — without leaving the sheet.
Read the 'P&L Summary' sheet, format the data as a styled HTML table with alternating row colors, bold header row, and a totals row at the bottom — negative numbers in red — send it to DocRaptor to create a PDF, and put the download URL in cell B2.
What You Get
- A DocRaptor-generated PDF with styled formatting: alternating row colors, bold headers, red negative values, totals row.
- The download URL written to cell B2 — shareable immediately.
- The HTML is built from the current state of the sheet, so re-running the prompt next month produces a new PDF with updated numbers.
- Errors surface as a plain-text note in B2 if the DocRaptor job fails, so you're not left wondering what happened.
What If the Data Is Not Quite Ready
The P&L has a mix of number formats — some rows are raw dollars, others are percentages
Read the 'P&L Summary' sheet. Before generating the PDF, normalize all dollar values to two decimal places and convert any decimal percentages (e.g. 0.12) to percentage format (e.g. 12%). Then format as a styled HTML table with alternating rows, send to DocRaptor, and write the URL to B2.
The summary data is split across two tabs — 'Q1 Actuals' and 'Q2 Actuals'
Pull data from both the 'Q1 Actuals' and 'Q2 Actuals' tabs, combine them into a single table ordered by month, format as a styled HTML table with alternating rows and a grand totals row, generate the PDF via DocRaptor, and put the URL in cell B2 of the 'Q2 Actuals' tab.
There are a few rows tagged 'Draft' in column E that shouldn't appear in the board PDF
Read the 'P&L Summary' sheet, exclude any rows where column E contains 'Draft', format the remaining rows as a styled HTML table with alternating colors and a totals row, generate a PDF via DocRaptor, and write the URL to B2.
Build, format, generate the PDF, and log it — in one shot
Read the 'P&L Summary' sheet, exclude Draft rows (column E), normalize all dollar values to two decimal places and percentage fields to display format, combine with the prior quarter from 'Q1 Actuals', produce a styled HTML table with alternating rows and red negative values, generate a PDF via DocRaptor, write the URL to B2, and append the date, tab name, and URL as a new row in the 'PDF Log' tab.
One prompt does the cleanup, the join, the formatting, and the logging. You don't have to chain four separate tasks.
Try It
Get the 7-day free trial of SheetXAI and open any P&L or financial summary sheet you've been manually exporting to PDF — then tell SheetXAI to format and generate the PDF via DocRaptor. See also: batch-generate multiple PDFs at once or pull the full DocRaptor document audit log.