How to r/w between Google Spreadsheet and Firebase Storage?
<p>I have a Google spreadsheet with a list of image filenames in rows (e.g. <code>tree01</code>, <code>tree02</code>, <code>car01</code>, <code>building01</code>, etc.) and I have a Firebase Storage with a list of image files with the same name (e.g. <code>tree01</code>, <code>tree02</code>, <code>car01</code>, <code>building01</code>, etc.).</p>

<p>How can I get the filename in spreadsheet? Then use the filename to get a download URL in Firebase storage and then put the download URL back to the spreadsheet?</p>

<p>I know how to use Google App Script to r/w with spreadsheet. I have searched online that using Google Web App, using "Web Server for Chrome" and get the download URL from Firebase Storage, but I don't know how to put them together. Please help.</p>