Using database without the backend

You can connect to certain sheets directly by publishing it to the web, so that data can be accessed without using backend routes. This method is for reading data only, you need the backend to update data.

To publish the database sheets:

  1. From menu File > Publish to the web...
  2. Toggle Published content & settings
  3. Select certain sheets
  4. Click Start publishing

Now, the client can access the data directly, without costing any backend execution quota.