Book Brand Consultation

To feed all lead form submissions directly into your Google Sheets, perform these steps:

1. Create a new Google Sheet named "Nitz's Media Leads".
2. In Google Sheets, go to Extensions > Apps Script.
3. Delete any code in the editor and paste the following snippet:

   function doPost(e) {
     try {
       var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
       var data = JSON.parse(e.postData.contents);
       
       // Add Headers if Sheet is empty
       if (sheet.getLastRow() === 0) {
         sheet.appendRow(["Timestamp", "Name", "Business Name", "Industry", "Instagram", "Challenges", "Budget", "Services"]);
       }
       
       sheet.appendRow([
         new Date(),
         data.name,
         data.businessName,
         data.industry,
         data.instagram,
         data.challenges,
         data.budget,
         data.services.join(", ")
       ]);
       
       return ContentService.createTextOutput(JSON.stringify({"result": "success"}))
         .setMimeType(ContentService.MimeType.JSON);
     } catch (error) {
       return ContentService.createTextOutput(JSON.stringify({"result": "error", "error": error.toString()}))
         .setMimeType(ContentService.MimeType.JSON);
     }
   }

4. Click Deploy > New Deployment. Choose Web App as deployment type.
5. Under Execute as, choose Me. Under Who has access, select Anyone.
6. Click Deploy, approve the permissions, and copy the Web App URL.
7. Open this file (contact/index.html) and replace PLACEHOLDER_URL inside the form tag with your deployed URL.

Once deployed, every request triggers instant logging in your spreadsheet without database setup.