Describe the issue/error/question
Using Stripe trigger to pass successful payment information to google sheets, everything works great when I execute the workflow manually. However when I active the workflow, data will appended twice in google sheets.
Please share the workflow
Share the output returned by the last node
[{
"id": "evt_1Ksvb6C7SDIUixqHLuDE69lF",
"object": "event",
"api_version": "2020-08-27",
"created": 1651007219,
"data": {
"object": {
"id": "in_1KsvasC7SDIUixqHLnsktqpw",
"object": "invoice",
"account_country": "HK",
"account_name": "Facebook",
"account_tax_ids": null,
"amount_due": 8000,
"amount_paid": 8000,
"amount_remaining": 0,
"application_fee_amount": null,
"attempt_count": 1,
"attempted": true,
"auto_advance": false,
"automatic_tax": {
"enabled": false,
"status": null
},
"billing_reason": "manual",
"charge": "ch_3Ksvb4C7SDIUixqH1ntdJ5uQ",
"collection_method": "charge_automatically",
"created": 1651007206,
"currency": "hkd",
"custom_fields": null,
"customer": "cus_LZuWBzkEdlzyZq",
"customer_address": null,
"customer_email": "[email protected]",
"customer_name": "Benny Ko",
"customer_phone": null,
"customer_shipping": null,
"customer_tax_exempt": "none",
"customer_tax_ids": [],
"default_payment_method": null,
"default_source": null,
"default_tax_rates": [],
"description": null,
"discount": null,
"discounts": [],
"due_date": null,
"ending_balance": 0,
"footer": null,
"hosted_invoice_url": "https://invoice.stripe.com/example",
"invoice_pdf": "https://pay.stripe.com/invoice/example",
"last_finalization_error": null,
"lines": {
"object": "list",
"data": [{
"id": "il_1KsvazC7SDIUixqHDFoTisw3",
"object": "line_item",
"amount": 8000,
"currency": "hkd",
"description": "80",
"discount_amounts": [],
"discountable": true,
"discounts": [],
"invoice_item": "ii_1KsvazC7SDIUixqHY1pghXoq",
"livemode": false,
"metadata": {},
"period": {
"end": 1651007213,
"start": 1651007213
},
"plan": null,
"price": {
"id": "price_1KsvazC7SDIUixqHTPdDWFfV",
"object": "price",
"active": false,
"billing_scheme": "per_unit",
"created": 1651007213,
"currency": "hkd",
"livemode": false,
"lookup_key": null,
"metadata": {},
"nickname": null,
"product": "prod_La5mojYnt2BpA4",
"recurring": null,
"tax_behavior": "unspecified",
"tiers_mode": null,
"transform_quantity": null,
"type": "one_time",
"unit_amount": 8000,
"unit_amount_decimal": "8000"
},
"proration": false,
"proration_details": {
"credited_items": null
},
"quantity": 1,
"subscription": null,
"tax_amounts": [],
"tax_rates": [],
"type": "invoiceitem"
}],
"has_more": false,
"total_count": 1,
"url": "/v1/invoices/in_1KsvasC7SDIUixqHLnsktqpw/lines"
},
"livemode": false,
"metadata": {},
"next_payment_attempt": null,
"number": "19F60EAB-0011",
"on_behalf_of": null,
"paid": true,
"paid_out_of_band": false,
"payment_intent": "pi_3Ksvb4C7SDIUixqH1G7kSP18",
"payment_settings": {
"payment_method_options": null,
"payment_method_types": null
},
"period_end": 1653557644,
"period_start": 1650965644,
"post_payment_credit_notes_amount": 0,
"pre_payment_credit_notes_amount": 0,
"quote": null,
"receipt_number": null,
"starting_balance": 0,
"statement_descriptor": null,
"status": "paid",
"status_transitions": {
"finalized_at": 1651007217,
"marked_uncollectible_at": null,
"paid_at": 1651007217,
"voided_at": null
},
"subscription": null,
"subtotal": 8000,
"tax": null,
"test_clock": null,
"total": 8000,
"total_discount_amounts": [],
"total_tax_amounts": [],
"transfer_data": null,
"webhooks_delivered_at": 1651007206
}
},
"livemode": false,
"pending_webhooks": 3,
"request": {
"id": "req_4ZIzyuynfZ1BLy",
"idempotency_key": "25476fca-427d-4dcf-bd6a-4bcf8f28bd7f"
},
"type": "invoice.payment_succeeded",
"Date Unix": 1651007206,
"Amount": 80,
"Name": "Benny Ko",
"Email": "[email protected]",
"Currency": "hkd",
"Transaction_ID": "pi_3Ksvb4C7SDIUixqH1G7kSP18",
"Invoice_No": "19F60EAB-0011",
"Invoice_Detail": "https://invoice.stripe.com/example",
"Description": "one_time"
}]
Information on your n8n setup
- **n8n version: 0.174.0
- Database you’re using (default: SQLite):
- Running n8n with the execution process [own(default), main]:
- Running n8n via [Docker]: