# Ready File DIY Kit — Google Docs/Sheets Setup Guide

This guide explains how to convert the markdown forms to Google Docs or Google Sheets for fillable use.

---

## Option 1: Google Docs (for narrative forms)

Forms that work best as Google Docs:
- Start Here Guide
- First 24 Hours Checklist
- First 30 Days Checklist
- Annual Review Checklist
- Questions for Your Lawyer / Advisor / Broker

### Setup Steps

1. **Copy markdown content:**
   ```bash
   cat /home/finneigan/.openclaw/projects-barnaby/readyfile/diy-kit/01-start-here-guide.md
   ```

2. **Create Google Doc:**
   - Go to docs.google.com
   - Create new document
   - Name it: "Ready File — Start Here Guide"

3. **Paste content:**
   - Paste markdown content
   - Use "Format > Clear formatting" then apply:
     - Headings: "Heading 1" / "Heading 2" (Source Serif 4 equivalent)
     - Body: Normal text (Inter equivalent)
     - Colors: Use hex codes from branding guide

4. **Add tables:**
   - Copy table markdown to a Google Sheet first
   - Convert to a clean table format
   - Paste into Google Doc

5. **Add fillable fields:**
   - Use "Insert > Table" for structured input
   - Add checkboxes with "Insert > Checkbox"
   - Leave blank cells for text input

6. **Share and organize:**
   - Move to "Ready File DIY Kit" folder
   - Share with spouse/partner as editor

---

## Option 2: Google Sheets (for tracker forms)

Forms that work best as Google Sheets:
- Emergency Contact Map
- Key Document Location Tracker
- Insurance and Benefits Inventory
- Household Operating Manual
- Bills and Subscriptions Tracker
- Children's Routine and Caregiver Notes
- Pet Care Sheet
- Digital Access Planning Worksheet
- Professional Contacts Sheet

### Setup Steps

1. **Copy markdown table content:**
   ```bash
   cat /home/finneigan/.openclaw/projects-barnaby/readyfile/diy-kit/03-emergency-contact-map.md
   ```

2. **Create Google Sheet:**
   - Go to sheets.google.com
   - Create new spreadsheet
   - Name it: "Ready File — Emergency Contact Map"

3. **Paste tables:**
   - Paste markdown table content directly
   - Sheets will auto-convert to spreadsheet format
   - Adjust column widths for readability

4. **Format with branding:**
   - Header rows: bold, sage background (`#7D9277`)
   - Borders: light gray (`#E6D8C3`)
   - Text color: deep ink (`#17211B`)
   - Font: Inter (11pt body, 10pt headers)

5. **Add data validation (optional):**
   - Use "Data > Data validation" for dropdowns (Yes/No, priorities)
   - Add checkboxes for binary fields

6. **Share and organize:**
   - Move to "Ready File DIY Kit" folder
   - Share with spouse/partner as editor

---

## Branding for Google Docs/Sheets

### Colors

| Use | Hex |
|-----|-----|
| Background | `#F7F3EA` |
| Headers | `#17211B` |
| Subheaders | `#243B53` |
| Accent | `#7D9277` |
| Borders | `#E6D8C3` |
| Warnings | `#C97C5D` |

### Typography

- **Headings:** 16–22pt, bold, serif style
- **Body:** 11–12pt, sans-serif style
- **Table headers:** 10–11pt, bold
- **Table body:** 10–11pt

---

## Automation (Optional)

If you want to automate the Google Docs/Sheets creation, use the Google Apps Script API:

1. Enable Google Drive API
2. Create a script to:
   - Read markdown files
   - Parse tables
   - Create Google Docs/Sheets
   - Apply formatting

Example starter snippet:

```javascript
function createReadyFileForm(formName, markdownContent) {
  const doc = DocumentApp.create('Ready File — ' + formName);
  const body = doc.getBody();
  body.appendParagraph(markdownContent);
  doc.saveAndClose();
  
  // Apply formatting...
}
```

---

## Next Steps

1. Start with Google Sheets for tracker forms (simpler, immediate fillable access)
2. Move Google Docs for narrative forms
3. Share with family for collaborative use
4. Set up annual review reminders

---

## Notes

- Google Docs/Sheets versions are fillable by default
- Multiple people can edit simultaneously
- Version history is automatic
- Offline access available via Google Drive desktop app