♻️ Mumbai Scrap Buyers
Office & Industrial Scrap Dismantling
📞 Call Now WhatsApp
Home Office Scrap Buyers Industrial Scrap Bandra Andheri Lower Parel Navi Mumbai Thane Pune Estimator Blog Contact 📞 Call Now WhatsApp Us
Home / Website Guide

Website Owner Guide

Step-by-step instructions for updating photos, the blog, and Google Sheet-driven content. No coding needed for daily updates.

1️⃣ Add / Change Photos via Google Sheet

  1. Open Google Sheets and create a new sheet named MSB-Content.
  2. In row 1, add exactly these column headers: category | title | image_url
  3. From row 2 onward, add one photo per row:
    • category: type gallery for the photo gallery, or review for a review-photo.
    • title: a short caption, e.g. Factory Dismantling – Bhiwandi.
    • image_url: a direct image link. Easiest way — upload the photo to Google Drive → right-click → Share → "Anyone with the link" → then use a direct-image link service, or simply host the image on any free image host (e.g. imgbb.com) and paste that direct link here.
  4. Click File → Share → Publish to web, choose the sheet, select CSV format, and click Publish. Copy the link given.
  5. Image SEO tip: before uploading each photo, rename the file to something descriptive with keywords, e.g. office-scrap-pickup-andheri-mumbai.jpg instead of IMG_2031.jpg — this genuinely helps the photo show up in Google Image search. Also keep the title column caption short and descriptive (used as the image's alt text).
  6. Open js/main.js in your website files, find the line starting with const SHEET_CSV_URL = and paste your link between the quotes.
  7. Save and re-upload/redeploy to Netlify. New photos will now appear automatically — no further code changes needed, just add new rows to the sheet any time.

2️⃣ Daily Scrap Rate Strip (Home Page News Section)

  1. Create another sheet tab named MSB-Rates with two columns: date and message.
  2. Add a new row each day, e.g. 05-Jul-2026 | Copper and office e-waste rates updated — WhatsApp us for today's price.
  3. Publish this sheet to web as CSV (same steps as above) and paste the link into RATE_SHEET_CSV_URL in js/main.js.
  4. The homepage automatically shows the most recent row.

3️⃣ Writing a Blog Post (Owner Only)

The blog is intentionally locked so only you can publish — visitors cannot post.

  1. Go to /blog-admin.html and enter the owner password (set inside that file — change it any time by editing the password value near the bottom of blog-admin.html).
  2. Recommended easier method: create a sheet tab MSB-Blog with columns date, title, content, image_url. Add a new row whenever you want to publish a post, publish that sheet to web as CSV, and share that link with your developer once — after that, every new row you add appears on /blog.html automatically, with no further edits needed.

4️⃣ Updating Google Analytics / Ads / GTM

All tracking codes (Google Tag Manager GTM-NKT8VDWV, Google Analytics G-T25L501ZQP, and the site verification meta tag) are already placed in every page's <head> via build.py. To change any ID in future, update it once at the top of build.py and re-run the generator — it updates every page automatically.

6️⃣ AI Search & Multi-Engine Optimization

This site is now optimized for traditional search (Google, Bing) and AI answer engines (ChatGPT, Perplexity, Google AI Overviews, Copilot):

Still to do manually (can't be done from code):

  1. Verify the site in Bing Webmaster Tools and submit /sitemap.xml there too (this also feeds Bing Chat/Copilot).
  2. Verify in Google Search Console using the existing site-verification meta tag already in every page's <head>, then submit the sitemap.
  3. Once live, test rich results at Google's Rich Results Test to confirm the FAQ/LocalBusiness schema is read correctly.

7️⃣ Deploying to Netlify

  1. Download/zip the full website folder.
  2. Go to Netlify → Add new site → Deploy manually → drag and drop the folder/zip.
  3. Once live, connect your domain mumbaiscrapbuyers.com under Domain Settings.
💬 📞