- Step1: Install PDF AI Sheet Add-on from the Google Workspace Marketplace.
- Step2: Activate the add-on under 'Extensions' in Google Sheet.
- Step3: Upload PDFs at https://capgo.ai/doc-at-scale to generate PDF IDs.
- Step4: Use the formula =ai_pdf(prompt, PDF_ID) to ask questions to PDFs.
- Step5: Drag the formula to apply it to multiple PDFs in bulk.
- Step6: Add 1 at the end of the formula to include reference page numbers in the output.