Skip to content

An open source sheet-to-site template for personal travel log. Built with Google Sheets API.

License

Notifications You must be signed in to change notification settings

yuinchien/traces.report

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

traces.report

alt text

This project aims to surface travel patterns that might be hidden and shed new light on the relationship between people and places. Checkout the sample site generated from the spreadsheet at traces.report. You can create and access your personal site at traces.report/me using localStorage.

alt text

Create your personal site

It's easy to create one. Follow the steps:

  1. Create a Google spreadsheet following the spreadsheet template

  2. Change the share permission to Anyone who has the link can view:
    Share > Advance > Change... > On - Anyone with the link > Save alt text

  3. Find the Google spreadsheet ID directly from your sheet url:
    alt text

  4. Go to traces.report/me and save your sheet ID to localStorage

  5. You can now access your personal site at traces.report/me

Please file issue or get in touch if there's any problem.

Notes

I've been keeping travel records in a Google Spreadsheet for many years, and this project has evolved over time. The current design enables me to reflect on my personal history and the relationship with different places I've lived, visited and left. Learn more about the design at yuinchien.com/traces-report.

Special thanks to @liquidx and @jonobr1 for pointing me in the right direction, and friends who inspire and brainstorm ideas with me!