Official Technical Support & Customer Care for PayloadFlatten for Google Sheets™
Our engineering support team monitors inquiries around the clock. Whether you need help un-nesting a custom webhook format or have billing questions, we guarantee a response within 24 business hours.
Ensure the cell you are referencing contains valid text. If referencing a range (e.g. A2:A50), ensure at least one cell in that range contains non-empty JSON data.
The raw payload text in your cell may have unescaped quotation marks or truncated brackets. Verify your webhook source sends standard stringified JSON (RFC 8259 compliant).
=FLATTEN_JSON(A2:A) creates 1 row per order and spreads line items sideways (line_items.0.sku, line_items.1.sku). Columns that already exist never move when bigger orders arrive.
For 1 row per line item, use =FLATTEN_JSON_ROWS(A2:A, "line_items") (or choose 1 row per line item in the sidebar). Order fields repeat on every row and an item_number column counts items 1, 2, 3… To add up order totals without double-counting, use =SUMIF(item_number_column, 1, total_column).
When you purchase a Lifetime License via Lemon Squeezy, your unique license key is emailed to you instantly on your purchase receipt and displayed on the confirmation screen.
To install or open in Google Sheets™: Install from the Google Workspace Marketplace, click the PayloadFlatten icon in the right-side panel of Google Sheets™, paste your key under Pro license, and click Activate license. If you cannot locate your purchase receipt, email us at payloadflatten@gmail.com with your checkout email address.
PayloadFlatten operates 100% inside your private Google account sandbox. We do not store, log, or inspect spreadsheet contents. Our application uses minimal document-level scopes (spreadsheets.currentonly). For full compliance disclosures, see our Privacy Policy.
We offer a no-questions-asked 14-day money-back guarantee on all Lemon Squeezy purchases. If PayloadFlatten does not fit your workflow, email us within 14 days of purchase and we will issue a full refund immediately.
Trademark Notice: Google Sheets™ and Google Workspace™ are trademarks of Google LLC. Shopify® is a trademark of Shopify Inc. Stripe® is a trademark of Stripe, Inc. Make® is a trademark of Celonis SE. n8n® is a trademark of n8n GmbH. PayloadFlatten is an independent software tool and is not endorsed by, sponsored by, affiliated with, or associated with Google LLC or any of these third-party companies.