Sheet Template Guide
Learn how to format your Google Sheet to create a live, synced folder structure for the FieldDrop app.
Make a Copy of the Template →STRUCTURE exactly for the app to recognize it.
The Core Structure
Use the following data format in your STRUCTURE tab. You can add as many rows as your organization requires.
| ORDER | TYPE | DISPLAY_NAME | DRIVE_FOLDER_URL | PARENT_ORDER | WEBHOOK_URL | DISABLED |
|---|---|---|---|---|---|---|
| A | FOLDER | General Contractors | ||||
| A1 | PROJECT | Smith Construction | https://drive.google.com/... | A | ||
| B | FOLDER | Archive | TRUE |
Column Breakdown
A unique identifier for sorting. Use letters (A, B, C) or numbers with leading zeros (01, 02) to ensure correct alphabetical sorting in the app.
Set as FOLDER for high-level groupings or PROJECT for actual jobsites. Primarily used for visual organization.
The name that will appear in the FieldDrop project list for your technicians.
The full Google Drive URL for the project. The app automatically extracts the Folder ID to route photos correctly.
Link a project to a folder by entering the folder's ORDER value here. Leave blank for top-level items.
Add a Google Chat Webhook URL here to receive instant notifications when new photos are uploaded to that project.
Enter TRUE or yes to hide an entire folder or project from the app without deleting the data.