Export your data to Google Sheets

Open an export in Google Sheets

1. Export the CSV

In the Alva admin, click an export at the top of the page. Dates read dd-MM-yyyy HH:mm in your store's time zone.

• Orders → Export Orders: one row per purchase, with customer, product, access status and license keys.
• Orders → Export download activity: one row per download page visit or button click. In the dialog, optional From and To days in your store's time zone limit the range; click Export.
• Products → Export catalog: one row per file, pack, link or license key pool on each product.

2. Import it into Google Sheets

Choose File → Import → Upload and select the CSV. Set Import location to Replace spreadsheet, or Insert new sheet(s) to keep your other tabs, and Separator type to Comma. Click Import data. Opening the CSV from Google Drive works too.

3. Check the dates

If day and month look swapped, or dates stay as text, pick a day-first locale such as United Kingdom in File → Settings and import again.

Add new rows automatically with Shopify Flow

Build the workflow yourself in Shopify Flow: Alva's Digital file downloaded or Digital purchase delivered trigger, followed by the Google Sheets Add row to spreadsheet action. Suggested columns for downloads: Date, Order, Customer email, Product, File. For deliveries: Date, Order, Customer email, Products, Files (number of files).

File is the file clicked, or Multiple files for a ZIP or multi-file button, or Unknown file when the product has no files. Products shows the ZIP's delivery name (or a generated one), not the Shopify product title, except license-key-only products, which show the product title.

1. Prepare the sheet

Create the tab first, with a header row for your columns, starting in column A.

2. Add the trigger and the action

In Shopify Flow, click Create workflow. Choose Alva's Digital file downloaded or Digital purchase delivered trigger, then add the Google Sheets Add row to spreadsheet action.

3. Connect Google Sheets in Flow

When Flow asks, sign in to your own Google account and allow it to edit spreadsheets. Alva never sees that account.

4. Fill in the action and turn it on

Paste the Spreadsheet URL and type the Tab name exactly. In Row contents (comma separated), paste the line for your workflow as one line. Each value fills one column in your header row's order, and commas are stripped from text values so they can't split a column.

Downloads workflow (Date, Order, Customer email, Product, File):

{{ "now" | date: "%Y-%m-%d %H:%M" }},{{ order.name | replace: ",", " " }},{{ order.email | replace: ",", " " }},{{ product.title | replace: ",", " " }},{{ fileName | replace: ",", " " }}

Deliveries workflow (Date, Order, Customer email, Products, Files):

{{ "now" | date: "%Y-%m-%d %H:%M" }},{{ order.name | replace: ",", " " }},{{ order.email | replace: ",", " " }},{{ productNames | replace: ",", ";" }},{{ totalFiles | round }}

Customer email uses order.email because a guest order has no customer. If a value that starts with = shows up as a formula in your sheet, add | prepend: "'" to the text values, never to Date or Files. Click Turn on workflow.