Firebase Studio - Google Sheets Manager

This is a Next.js application built in Firebase Studio to help you manage data in a Google Sheet.

How to Get Started

1. Open Google Sheets: Create a new Google Sheet or use an existing one.
2. Open Apps Script: In your sheet, go to Extensions > Apps Script.
3. Copy Script Files:
   • Delete any existing code in the Code.gs file within the Apps Script editor.
   • Copy the content from src/apps-script/Code.js in this project into the Code.gs file in the editor.
   • Create a new HTML file in the Apps Script editor by clicking the + icon next to Files and selecting HTML. Name it Sidebar.html.
   • Copy the content from src/apps-script/Sidebar.html into your new Sidebar.html file.
   • In the Apps Script editor, open the Project Settings (gear icon on the left) and check the box for "Show appsscript.json manifest file in editor".
   • Return to the editor, and you will see an appsscript.json file. Copy the contents from src/apps-script/appsscript.json into it.
4. Deploy as a Web App:
   • Click the Deploy button in the top right, then select New deployment.
   • Click the gear icon next to Select type and choose Web app.
   • For Who has access, select Anyone, Anonymous.
   • Click Deploy.
5. Authorize Permissions: You will be prompted to authorize the script. Follow the on-screen instructions. You may see a warning that the app isn't verified; you can proceed by clicking "Advanced" and then "Go to (your project name)".
6. Get Your IDs and URLs:
   • After deploying, copy the Web app URL.
   • Go to Project Settings (gear icon) and copy the Script ID.
7. Configure the Web App:
   • Run this application.
   • Navigate to the /settings page.
   • Paste your Sheet URL, Script ID, and Web app URL into the respective fields and click Save Configuration.
8. View Your Data: Navigate to the /data page to see the data from your sheet.