How to Log New Orders with Pipedream

Pipedream Dashboard > Workflows > New

Create new workflow in Pipedream

Navigate to pipedream.com and click New Workflow in the top right. You'll land on the workflow builder with an empty canvas. The interface shows Sources on the left and Steps on the right. Name your workflow something descriptive like 'Shopify Orders to Sheets'.

1. 1Click 'New Workflow' button in dashboard
2. 2Name workflow 'Shopify Orders to Sheets'
3. 3Click 'Create' to open workflow builder

Workflow Builder > Add Trigger > Shopify

Add Shopify webhook trigger

Click 'Add a trigger' and search for Shopify. Select 'New Order (Instant)' from the trigger options. This creates an instant webhook that fires the moment an order is placed. You'll see the webhook URL that Shopify will call.

1. 1Click 'Add a trigger' button
2. 2Search for 'Shopify' in the apps list
3. 3Select 'New Order (Instant)' trigger
4. 4Click 'Connect Account' for Shopify

Shopify Auth > Store Domain > Authorize

Connect your Shopify store

Click 'Connect Account' and enter your Shopify store domain without the .myshopify.com part. You'll be redirected to Shopify to authorize Pipedream. Grant access to orders, products, and customers. After authorization, you'll return to Pipedream with a green connected status.

1. 1Enter your store name (just 'mystorename', not full URL)
2. 2Click 'Connect' to redirect to Shopify
3. 3Click 'Install app' in Shopify admin
4. 4Return to Pipedream workflow builder

Shopify Trigger > Test > Generate Test Event

Test the Shopify trigger

Click 'Generate Test Event' to create sample order data, or place a real test order in your store. Pipedream will capture the webhook data and show you the full order object structure. This sample data helps you understand what fields are available for mapping to Google Sheets.

1. 1Click 'Generate Test Event' button
2. 2Wait 10-15 seconds for sample data to load
3. 3Expand the order object to see available fields
4. 4Note fields like order_number, customer, total_price

Workflow Builder > + Add Step > Google Sheets

Add Google Sheets action step

Click the '+' button below your trigger to add a new step. Search for Google Sheets and select 'Add Single Row'. This action will append a new row to your spreadsheet each time an order comes in. You'll need to specify which spreadsheet and worksheet to use.

1. 1Click the '+' button below Shopify trigger
2. 2Search for 'Google Sheets' in the actions
3. 3Select 'Add Single Row' action
4. 4Click 'Connect Account' for Google Sheets

Google Sheets Auth > Sign In > Grant Permissions

Connect Google Sheets account

Click 'Connect Account' and sign in with your Google account. Grant Pipedream permission to read and write your Google Sheets. After authorization, you'll return to the workflow with access to select your spreadsheets. The connection should show a green connected status.

1. 1Click 'Connect Account' in Google Sheets step
2. 2Sign in with your Google account
3. 3Grant Pipedream permissions to Google Sheets
4. 4Click 'Allow' to complete authorization

Google Sheets Step > Spreadsheet > Worksheet

Select spreadsheet and worksheet

Choose your target spreadsheet from the dropdown list. If you don't have one ready, create a new Google Sheet with headers like Order Number, Customer Name, Email, Total, Items. Select the specific worksheet tab where you want rows added. Most sheets default to 'Sheet1'.

1. 1Select your spreadsheet from the dropdown
2. 2Choose the worksheet tab (usually 'Sheet1')
3. 3Verify the sheet has headers in row 1
4. 4Click 'Refresh' if your sheet doesn't appear

Google Sheets Step > Field Mapping > Custom Expressions

Map Shopify data to sheet columns

Now map the Shopify order fields to your spreadsheet columns. Click each field dropdown and select the corresponding Shopify data. For line items, you'll need to format them as a readable list since Google Sheets expects text, not arrays. Use the custom expression builder for complex fields.

1. 1Map Order Number to steps.trigger.event.order_number
2. 2Map Customer Name to steps.trigger.event.customer.first_name + last_name
3. 3Map Email to steps.trigger.event.customer.email
4. 4Map Total to steps.trigger.event.total_price
5. 5Map Items using custom expression for line_items array

Workflow Builder > + Code Step > Node.js

Add custom code for line items formatting

Add a code step before Google Sheets to format the line items nicely. Click '+' between Shopify and Sheets, then select 'Node.js Code'. Write code to loop through line_items and create a readable string with product names, quantities, and prices. Return the formatted data for the Sheets step.

1. 1Click '+' between Shopify trigger and Google Sheets
2. 2Select 'Run Node.js Code' action
3. 3Paste the line items formatting code
4. 4Update Google Sheets mapping to use code step output

This code step formats Shopify line items into readable text for your Google Sheet. Paste it in a Node.js code step between Shopify and Google Sheets.

export default defineComponent({
  async run({ steps, $ }) {
    const order = steps.trigger.event;

export default defineComponent({
  async run({ steps, $ }) {
    const order = steps.trigger.event;
    
    // Format line items into readable string
    const formattedItems = order.line_items.map(item => {
      const price = parseFloat(item.price).toFixed(2);
      return `${item.title} (${item.quantity}x $${price})`;
    }).join(', ');
    
    // Format customer name safely
    const customerName = [
      order.customer?.first_name || '',
      order.customer?.last_name || ''
    ].filter(name => name.length > 0).join(' ') || 'Guest';
    
    // Format order total with currency
    const orderTotal = `${order.currency} ${parseFloat(order.total_price).toFixed(2)}`;
    
    // Return formatted data for Google Sheets
    return {
      order_number: order.order_number,
      customer_name: customerName,
      customer_email: order.customer?.email || '',
      total_price: orderTotal,
      line_items: formattedItems,
      created_at: new Date(order.created_at).toLocaleDateString(),
      fulfillment_status: order.fulfillment_status || 'unfulfilled',
      financial_status: order.financial_status || 'pending'
    };
  },
});

Workflow Builder > Test > Check Google Sheet

Test the complete workflow

Click 'Test' at the top of the workflow to run it with your sample data. Check your Google Sheet to confirm a new row was added with all the mapped order information. The test should complete in 2-3 seconds. If successful, you'll see green checkmarks on each step.

1. 1Click 'Test' button in top toolbar
2. 2Wait for all steps to complete
3. 3Open your Google Sheet in new tab
4. 4Verify new row contains correct order data

Workflow Builder > Deploy > Events Monitor

Deploy workflow to production

Click 'Deploy' to activate your workflow for live orders. The webhook will now process real Shopify orders and add them to your sheet within 30 seconds. You can monitor execution in the Events tab and pause/resume the workflow anytime from the main dashboard.

1. 1Click 'Deploy' button in top right
2. 2Confirm deployment in modal dialog
3. 3Navigate to Events tab to monitor activity
4. 4Place a test order to verify live processing