Sheetany lets you turn Google Sheets into a website with just a few simple steps. If you want to automate this process via API, here’s a complete guide.
1. Prerequisites
- A Google Sheet set to public (anyone with the link can view).
- An API token (for authentication).
- The public Google Sheets URL (doc_url).
2. Fetch Sheet Information
First, you need to fetch data from the sheet using the following API:
Endpoint:
GET https://api.sheetany.com/api/v1/sites/sheet?doc_url={url}
Header:
Authorization: Bearer {token_here}
- {url}: Public Google Sheets link.
- {token_here}: Your API token.
Response will include two main parts:
- Information sheet: metadata and configuration.
- Content sheet: actual website content.
Example (simplified):
3. Create a Website with Retrieved Data
Once you have the sheet data, use it to create a new site.
Endpoint:
POST https://api.sheetany.com/api/v1/sites
Header:
Authorization: Bearer {token_here}
Content-Type: application/json
Body:
Where:
- information and content are taken directly from the GET response in step 2.
- template is the template code you want to apply.
4. Available Templates
Sheetany provides a wide range of templates to fit different needs:
100 - BLOG
110 - BLOG_PERSONAL
120 - BLOG_BORDER
200 - DIRECTORY
210 - DIRECTORY_SMALL
220 - DIRECTORY_CLEAN
300 - LANDING_PAGE
400 - PRODUCT_ROADMAP
500 - HELP_CENTER
600 - DOCUMENTATION
700 - PRODUCT_VOTE
800 - LISTING
810 - LISTING_BOX
900 - JOB_BOARD
910 - JOB_BOARD_CLEAN
1000 - EVENT
1100 - ECOMMERCE
1110 - ECOMMERCE_FASHION
1200 - WAIT_FORM
1300 - BOOK
1400 - PERSONAL
1500 - CHANGELOG
1600 - AFFILIATE
1700 - LEARNING
1800 - REAL_ESTATE
1900 - TRAVEL
2000 - VIDEO
2100 - TABLE
5. Conclusion
With just two main steps — GET sheet data and POST to create a site — you can transform a Google Sheet into a full website. Sheetany’s API makes the process automatic and flexible, whether for personal projects or business use.
