• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Problem with GoogleSheets

kyron900

Member
Hello ,

I've successfully linked my WooCommerce site with Pabbly to export orders to Google Sheets. However, I'm struggling to retrieve this data from Google Sheets to create invoices through Stripe. How can I effectively connect Google Sheets to my Stripe invoicing process? Thanks.
 

ArshilAhmad

Moderator
Staff member
Hi @kyron900,

Please watch the video attached below to understand how you can setup Google Sheets as your trigger application to capture newly added data. Only the first half is relevant for your use case.

You can use Stripe: Create an Invoice action event to create invoice using the captured data.
1691098927865.png
 

kyron900

Member
hello thank you for response , I create new workflows (GoogleSheets > Stripe) , I have data of customers intro googlesheets I setup it but one I select next step (stripe) to create invoice I got this error , Please check the screenshot on attachment .

Thanks
 

Attachments

  • Screen Shot 2023-08-08 at 7.25.32 AM.png
    Screen Shot 2023-08-08 at 7.25.32 AM.png
    276.1 KB · Views: 41
  • Screen Shot 2023-08-08 at 7.25.52 AM.png
    Screen Shot 2023-08-08 at 7.25.52 AM.png
    237.2 KB · Views: 51

ArshilAhmad

Moderator
Staff member
Please use the Stripe: Retrieve a Customer by Email action event to fetch the Customer ID, and then map that ID to its corresponding field in the "Create an Invoice" action event.

1691521765697.png
 

kyron900

Member
thank you for response but what this action I dont understand , to have clear idea I have clients on CSV but not exist on stripe I want from the workflows to get the infos from CSV on googlesheets and send invoice with name , last name , price and email to client
 

ArshilAhmad

Moderator
Staff member
If the customer does not already exist in your Stripe account, use the "Stripe: Create a Customer" action event to create a new customer, and then map the customer ID in the "Stripe: Create an Invoice" action event.
1691535860264.png


Please watch the video attached below to understand how you can setup Stripe: Create a Customer action event (Ignore the trigger application).
 

kyron900

Member
yes Thank you I create the senario but I got again issue
 

Attachments

  • Screen Shot 2023-08-09 at 2.49.21 AM.png
    Screen Shot 2023-08-09 at 2.49.21 AM.png
    259.3 KB · Views: 43
  • Screen Shot 2023-08-09 at 2.49.41 AM.png
    Screen Shot 2023-08-09 at 2.49.41 AM.png
    908.3 KB · Views: 45
  • Screen Shot 2023-08-09 at 2.49.59 AM.png
    Screen Shot 2023-08-09 at 2.49.59 AM.png
    716.6 KB · Views: 40

ArshilAhmad

Moderator
Staff member
Stripe does not accept decimals in the Application Fee Amount. If you enter 7495, it will be treated as 74.95 in Stripe.
1691608701537.png
 
Top