AppSheet Sync Skipper

About

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.