Ship an AI RFP-scoring pipeline with n8n + Gemini, and mind the file limits (vs ChatGPT)
You can automate RFP scoring and spreadsheet analysis with Gemini today using n8n, while planning around concrete file-format and size limits across Gemini and ChatGPT. An end-to-end n8n workflow shows how to accept vendor PDFs via a form webhook, fetch the RFP from Drive, extract text, merge both streams, call the Gemini API with a structured prompt to return JSON scores, and append results to Sheets—plus Drive auth scopes and download details like alt=media are covered in this guide ([n8n + Gemini RFP evaluation](https://dev.to/hackceleration/building-ai-powered-rfp-evaluation-with-n8n-and-google-gemini-pf5)). For data handling at scale, Gemini supports XLS/XLSX/CSV/TSV and Google Sheets; Gemini chat allows up to 10 files per prompt at 100 MB each, while the Files API permits up to 2 GB per file and 20 GB per project for 48 hours—useful for batch or programmatic flows ([Gemini spreadsheet upload and limits](https://www.datastudios.org/post/google-gemini-spreadsheet-uploading-excel-and-csv-support-data-analysis-capabilities-formula-hand)). If you compare providers, ChatGPT accepts many document and data types but caps file size at 512 MB (with spreadsheet practical limits around ~50 MB) and also enforces token and image-specific ceilings, which can influence provider selection for large artifacts ([ChatGPT file upload limits](https://www.datastudios.org/post/chatgpt-file-uploading-capabilities-supported-file-types-upload-size-limits-rules-and-document-r)).