IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact
You are here: Home / How To / How to Obtain WorksheetId Within a Google Docs Spreadsheet

How to Obtain WorksheetId Within a Google Docs Spreadsheet

If you try to save form data to Google Spreadsheets and you have more than one worksheets, soon enough you’ll run into this issue trying to figure out how to get the id of the worksheet you need to update. While I don’t know how to obtain this id programmatically, there’s a practical way to do it and it should only take about a minute of your time.

Using the simple Sheet 23 in this Registration GDocs as an illustration, it’s obviously not the first and the only worksheet within the Google spreadsheet.

GDocs active worksheet

The first thing you need to do is just go to the File from the menu and select Publish to the Web…
GDocs - Publish to the Web

On the new screen that pops out, just follow these 4 steps as pictured below.

  1. Select the sheet you want to obtain the id
  2. Click on Start publishing button
  3. Select either ATOM (recommended) or RSS from the Get a link to the published data option
  4. If you choose ATOM, the link should come out in this format:

    http://spreadsheets.google.com/feeds/list/[spreadsheet key]/[worksheet id]/public/values

    Copy down the worksheet id from the provided link in circle. In this case, it’s the “ocz” but it may be different on yours (e.g., od4, od6, od8, and et cetera).

GDocs - Publish to the Web options screen

Unless you want to publish your worksheet now, you need to make sure you click back the Stop publishing button.

Click Close and you’re done.

Further Reading

Getting Started with the Google Data PHP Client Library
Google Data Protocol
Saving Form Data to Google Spreadsheets Using PHP and the Google Docs API
Zend Gdata Library Downloads

April 2, 2012 Filed Under: How To Tagged With: Google, PHP

Comments

  1. Hok Shun Poon says

    May 10, 2015 at 4:29 am

    This technique appears to be obsolete.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Buy me a coffee Support this site
Buy Me a Coffee?

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • Tips and Tricks
  • Use Case
  • WordPress
  • Writing

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication
  • RSS

Tags

.NET Access AdSense ASP.NET Cdonts Dll Classic ASP Code Editor ETL FSharp Genesis Framework Git Google HP Asset Manager HTML HTML5 Hugo IIS Information Security Internet Internet Information Services iOS JAMStack Linux macOS Microsoft Microsoft SQL Server MVC PHP Python Simple Mail Transfer Protocol Smtp Server Social Media SQL SQL Server SSIS SSMS SSRS Sublime Text Visual Studio Visual Studio Code VPN Windows Windows 8 Windows 10 Windows Server

Copyright © 2011-2022 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure