Admin Dashboard | InnocentInvestor

Dashboard Overview

Monitor inquiries, job applications, and article submissions.

Local Mode (LocalStorage)

0

Queries Received

0

Join Applications

0

Article Submissions

Google Sheets Connection Status

Form data is currently being saved to this browser's localStorage. Connecting a Google Sheets Web App URL allows you to automatically write new submissions directly into a Google Sheet spreadsheet, and view those live spreadsheet inputs in real-time.

Date	Name	Email	Purpose	Message	Actions

Date	Name	Email	Phone	Role	Actions

Date	Name	Email	Category	Title	Actions

Connection Details

Google Apps Script Web App Deployment URL

Paste the URL obtained when deploying your Google Apps Script macro code as a Web App (access set to 'Anyone').

Google Sheets Connector Setup Guide

1. Create spreadsheets inside Google Sheet

Create a Google Sheet and name it as you like. We will store incoming entries in separate sheets inside it.

2. Open Extensions Apps Script

At the top menu in your Google Sheet, click Extensions > Apps Script. This will open the editor interface.

3. Paste script macro code

Erase any template code inside the editor and paste the complete block below:

/* Loading... */

4. Deploy Web App

Click the blue Deploy button in the top right > select New deployment. In the dialog box:
- Click the gear icon next to "Select type" and pick Web app.
- Set "Execute as" to: Me (your email address).
- Set "Who has access" to: Anyone (this is required to allow submissions from forms).
- Click Deploy, authorize the Google permissions, and copy the generated Web App URL.