Use the Sheets API to allow external URL access for IMPORT and IMAGE functions without requiring each spreadsheet user to grant consent.
#sheets
2 posts tagged “sheets”. Follow along via the #sheets RSS feed.
Allow Sheets IMPORT and IMAGE URLs Apps Script Storage Benchmarks Benchmarks comparing CacheService, PropertiesService, and Firestore in Apps Script, including speed measurements and when each storage option fits.