Writing Google Apps Script functions for one-off tasks is easy, but scaling an operation to run for every row in a sheet with stability is anything but. That's why we developed loopSheet, a framework that allows developers to quickly create solutions that span their entire system. One library installation allows you to take any function and run it for every row without having to worry about time-out limitations or API failures. loopSheet serves as xSoTec’s main building block for custom client systems, powering complex automation and system maintenance for nearly all active clients.

• Row-by-Row Execution: Converts standard Google Apps Script functions into scalable operations that run across every row in a sheet.
• Simple Implementation: Uses a lightweight framework—just add a library and a short template to your bound script to make any function infinitely iterative.
• Time-Limit Management: Automatically handles Google’s strict execution limits (such as the 6-minute timeout cap) so scripts can run reliably.
• Error Tracking: Systematically logs row-level and internal file errors to ensure data integrity and easier debugging.
• Granular Control: Provides built-in options to filter, configure, and select precisely which rows to process.
• Developer Focus: Eliminates complex workarounds for platform restrictions, allowing developers to focus on building creative solutions.

Whether it's parsing from a large list of student data or aggregating grades into a central spreadsheet, finding, manipulating and sending data from one place to another is always crucial. CopyScripts streamlines how you work with spreadsheets by giving you a way to build reliable systems where data is connected from one spreadsheet to another.

CopyScripts is a robust and configurable automation engine built to connect and manipulate data across Google Sheets without the limitations of IMPORTRANGE or standard queries.

It starts via a simple installation - one sheet that easily integrates with an existing spreadsheet. Through this sheet, you can quickly configure sophisticated CopyScripts reports, as it features a deep pool of options that allow you to create specific solutions that fit your system, even without needing to write any code. Reports can be ran manually or via a time-based trigger, giving your system the flexibility to process and update your data on a consistent basis.

CopyScripts transforms disconnected spreadsheets into a secure, automated database. Dozens of schools every day use CopyScripts to update personalized dashboard spreadsheets, aggregate grades, import data from external sources, and so much more.

Many of our systems have hundreds of Google Sheets that need to be quickly modified. adminConsole was developed as a way to organize, edit and create files using a single template. Simplifying mass updates for hundreds of spreadsheets simultaneously, adminConsole allows users to automatically insert new tabs, update design and spreadsheet contents, and manage sharing permissions and document locations within Google Drive automatically for hundreds of spreadsheets through a wide array of built-in functions.

Fundamentally, adminConsole and its integrated functions empower schools to effortlessly apply updates across all their active spreadsheets, even within large-scale setups that have already been launched.

Throughout our years developing custom systems for schools, we've designed an entire ecosystem of powerful functions that you can utilize to develop your own product. Here are just some of them!

• sendMergedMail: Create Documents, Set Permissions of documents, create PDFs of spreadsheets and attach to emails that you can customize through a Google Doc to standardize communication.
• addNewDashboards: Replicate folders for users, including entire dashboard/system templates to scale your system to an infinite amount of users.
• xConsole: Manage the scripts, settings, and design of spreadsheets. A game changer when it comes to pushing out updates to many sophisticated dashboards at once.
• driveCopy: Copy an entire Google Drive folder - even if there's thousands of items! Necessary for archival & replication of huge systems.
• And More!