AppSheet Sync Skipper

AppSheet Sync Skipper AppSheet Sync Skipper is a lightweight Chrome Extension that helps you skip the default sync process in AppSheet by directly sending data to your AppSheet app via its API. This enables faster actions, more efficient workflows, and a smoother experience when triggering changes or submitting form data. ⚙️ What it does: Detects special URLs with AppSheet parameters (e.g. ?appid=...&accesskey=...) Extracts information and sends it to AppSheet’s API Displays the status of requests (success, error, pending) Keeps a small log of recent API calls Automatically closes the triggering tab (if needed) This is useful for AppSheet developers who want to simulate form submissions, bypass sync delays, or build automation tools using AppSheet's public API. ------------------------ 📘 AppSheet Sync Skipper – User Guide 🎯 Purpose AppSheet Sync Skipper helps you skip manual Sync in AppSheet workflows by sending structured data directly to the AppSheet API via a custom URL. Ideal for performing Add, Edit, or Find actions with a single link. 🛠️ How to Use Step 1: Set up a "Go to a website" Action in AppSheet In your AppSheet app, create an action of type: "Go to a website" Use a URL formatted like: https://anythingxyz.com/?appid=...&accesskey=...&tablename=...&action=...&[column1]=...&[column2]=... ---------------- Send 1 row "https://yourdomain.com/" & SUBSTITUTE( "?appid=YOUR_APP_ID&accesskey=YOUR_API_KEY&location=" & TEXT("47.623098,-122.330184") & "&timezone=Pacific Standard Time&action=Add&Name=John&Status=Done", "%", "percent" ) ---------------- Send multiple rows (example: bulk update status) "https://yourdomain.com/" & SUBSTITUTE( "?appid=YOUR_APP_ID&accesskey=YOUR_API_KEY&location=" & TEXT("47.623098,-122.330184") & "&timezone=Pacific Standard Time&tablename=YourTable&action=Edit&batch=true&ID=123,124,125&Status=Done", "%", "percent" ) Explanation: ID=123,124,125 → 3 rows with 3 key IDs. Status=Done → Applied to all 3 rows. ---------------- Group Action (multiple actions) "https://yourdomain.com/" & SUBSTITUTE( "?appid=YOUR_APP_ID&accesskey=YOUR_API_KEY&location=" & TEXT("47.623098,-122.330184") & "&timezone=Pacific Standard Time" & "&action_1=Add&tablename_1=Orders&Name_1=John" & "&action_2=Edit&tablename_2=Invoices&ID_2=456&Status_2=Paid", "%", "percent" ) ------------------ Explanation: action: Add → Creates a new row in the Orders table. action: Edit → Updates the Invoices table. Step 2: Attach the link to a button, event, or automation When this URL is opened, the extension detects the parameters, sends a request to AppSheet's API, and then closes the tab automatically. 🔑 Required URL Parameters appid | Your AppSheet app ID accesskey | Your AppSheet API access key tablename | The name of the table to interact with action | One of: "Add", "Edit", or "Find" locale (optional) | Defaults to "en-US if not provided location (optional) | Defaults to "47.623098,-122.330184" if not provided timezone (optional) | Defaults to "Pacific Standard Time" if not provided Any other parameters | Treated as column names and values for the row data This will send a POST request to the AppSheet API to insert a new row into the Customers table. 📦 Logs & Status Click the extension icon to view a log of recent API requests. Each entry includes: - Success – Successfully sent to AppSheet - Error – Failed to send - Pending – Currently being processed Only the 10 most recent requests are saved in memory. ⚠️ Notes & Tips - It's recommended to open the link in a new browser tab to ensure the extension can capture and process it. - Make sure the Chrome Extension is installed and enabled on the browser where the action is triggered. - Do not include sensitive credentials like access keys in public actions unless you trust the user.