Files

The Files feature in Sheetrocks allows users to store, serve, and manage files directly from their workbooks. This feature provides flexibility for both internal app development and public-facing applications, including hosting static websites or serving other types of assets.

File Types Supported

Sheetrocks supports a wide variety of file types for both internal use and public hosting, such as:

Text-based files: .txt, .csv, .json
Document formats: .doc, .docx, .pdf, .xls, .xlsx
Image formats: .jpeg, .png
Web assets: .html, .css, .js, .map (JavaScript map files)

Note: Large media files, such as video formats, are not supported.

File Size Limit

There is a 50MB size limit per file. This size should accommodate most document types, image files, and web asset needs without difficulty. Files exceeding this size will require external hosting or alternative solutions.

Privacy and Access Controls

Files can be stored privately for internal app use, or they can be set to public, making them accessible via a URL. The privacy toggle in the file management interface allows you to switch between public and private settings with ease.

Private: Files stored privately are only accessible within the authenticated Sheetrocks environment and are protected by robust security mechanisms.
Public: Public files can be accessed by anyone with the URL, making it ideal for static assets like websites.

Security Note: Be cautious when sharing URLs to public files, as they will be accessible without authentication.

Integration with Webhooks and APIs

Sheetrocks integrates seamlessly with external services and workflows through webhooks and APIs. The Files feature supports interaction with external systems for file input and output, such as:

File Uploads:Upload files programmatically using the API or connect automation tools (e.g., Make.com) to push files directly into your Sheetrocks workbook.
File Storage for Webhooks: Webhooks can be used to serve data from your spreadsheet directly into static assets (like websites), or you can process data externally and store it back into Sheetrocks.

For instance, if you're generating PDFs (like invoices) from spreadsheet data, you can use automation tools to process the data, generate the file, and store it back in Sheetrocks for future reference. The resulting file is then available via URL or can be sent to clients.

Serving Static Files

Sheetrocks can be used to host static assets like HTML, CSS, and JavaScript files. These files can be referenced directly from a Sheetrocks URL, allowing users to host lightweight, dynamic websites or apps directly from their workbooks.

Text-base Static Websites: You can upload the necessary files (HTML, CSS, JavaScript) and host them directly from your Sheetrocks workbook, making it an efficient and scrappy way to launch custom web applications without needing external hosting files: .txt, .csv, .json

Interaction with Formulas and Other Features

Although files themselves are not directly manipulated through formulas, you can use Sheetrocks automation features to interact with files in the following ways:

· Upload files via automated workflows (e.g., through Make.com) and use formulas to organize and track these files.
· Automate the processing of files, such as reading and transforming data from Excel files before storing them back in Sheetrocks.

Tip: Use public file hosting for static assets that don’t contain sensitive data.

Tip: Keep sensitive documents private and ensure proper access controls are in place.

Tip: Integrate with automation tools to make the most out of your file storage by automating file generation, upload, and retrieval processes.