Creates every product in your price list in Stripe and records its shareable payment link on a tab, never twice.
Uses
Google Sheets
Stripe
Turn a price list into Stripe payment links
Set sheetUrl to blank.Set sheetUrl to blank.Set priceListTabName to blank.Set priceListTabName to blank.Set currency to blank.Set currency to blank.Set paymentLinksTabName to Payment links.Set paymentLinksTabName to Payment links.Set maxLinksThisRun to 1.Set maxLinksThisRun to 1.Set maxPricePerItem to 1000.Set maxPricePerItem to 1000.
Make currency lowercase and save it as currencyCode.Make currency lowercase and save it as currencyCode.
If the length of currencyCode is not 3If the length of currencyCode is not 3Yes
Stop and report a problem: The 'currency' step must hold a three-letter currency code such as usd, eur or gbp - not a currency symbol or a full name.Stop and report a problem: The 'currency' step must hold a three-letter currency code such as usd, eur or gbp - not a currency symbol or a full name.No
No steps
Create a list of [bif, clp, djf, gnf, jpy, kmf, krw, mga, pyg, rwf, ugx, vnd, vuv, xaf, xof, xpf] and save it as zeroDecimalCurrencies.Create a list of [bif, clp, djf, gnf, jpy, kmf, krw, mga, pyg, rwf, ugx, vnd, vuv, xaf, xof, xpf] and save it as zeroDecimalCurrencies.If zeroDecimalCurrencies contains currencyCodeIf zeroDecimalCurrencies contains currencyCodeYes
Stop and report a problem: This workflow reads prices written the everyday way (49.99) and multiplies by 100 to give Stripe the amount in cents. That is wrong for currencyCode, which has no smaller unit, so every payment link would ask for a hundred times the price. Nothing has been created.Stop and report a problem: This workflow reads prices written the everyday way (49.99) and multiplies by 100 to give Stripe the amount in cents. That is wrong for currencyCode, which has no smaller unit, so every payment link would ask for a hundred times the price. Nothing has been created.No
No steps
Round maxPricePerItem multiplied by 100 to the nearest integer and save it as maxAmountInSmallestUnit.Round maxPricePerItem multiplied by 100 to the nearest integer and save it as maxAmountInSmallestUnit.Set linksTabIsNew to true.Set linksTabIsNew to true.
If a step below fails, save the error as createLinksTabErrorIf a step below fails, save the error as createLinksTabErrorTry
Google SheetsCreate the tab paymentLinksTabName in sheetUrl.Create the tab paymentLinksTabName in sheetUrl.On error
Change linksTabIsNew to false.Change linksTabIsNew to false.If linksTabIsNew is yesIf linksTabIsNew is yesYes
Google SheetsAdd a row to paymentLinksTabName in sheetUrl.Add a row to paymentLinksTabName in sheetUrl.No
No steps
Google SheetsRead column 'A' of paymentLinksTabName in sheetUrl. Save it as publishedLog.Read column 'A' of paymentLinksTabName in sheetUrl. Save it as publishedLog.Set alreadyPublished to an empty list.Set alreadyPublished to an empty list.
For each loggedProduct in publishedLog.values:For each loggedProduct in publishedLog.values:If a step below fails, save the error as loggedProductErrorIf a step below fails, save the error as loggedProductErrorTry
Add loggedProduct in lowercase to the end of alreadyPublished and save it as alreadyPublished.Add loggedProduct in lowercase to the end of alreadyPublished and save it as alreadyPublished.On error
Show in the output: Ignored a cell in the '@paymentLinksTabName' tab that is not text.Show in the output: Ignored a cell in the '@paymentLinksTabName' tab that is not text.Set publishedThisRun to 0.Set publishedThisRun to 0.Set skippedRows to 0.Set skippedRows to 0.Set alreadyDoneRows to 0.Set alreadyDoneRows to 0.Get the stored value 'stripe_products_awaiting_link'. Save it as rememberedProducts.Get the stored value 'stripe_products_awaiting_link'. Save it as rememberedProducts.
Use rememberedProducts.value, or [] if it is empty and save it as productsAwaitingLink.Use rememberedProducts.value, or [] if it is empty and save it as productsAwaitingLink.Set stripeFailures to an empty list.Set stripeFailures to an empty list.Google SheetsRead the rows of sheetUrl. Save it as priceList.Read the rows of sheetUrl. Save it as priceList.For each row in priceList.rows:For each row in priceList.rows:If publishedThisRun is greater than or equal to maxLinksThisRunIf publishedThisRun is greater than or equal to maxLinksThisRunYes
Stop repeating.Stop repeating.No
No steps
Set rowLabel to row row.row_number as text.Set rowLabel to row row.row_number as text.Set productName to blank.Set productName to blank.If a step below fails, save the error as productNameErrorIf a step below fails, save the error as productNameErrorTry
Trim row.Product and save it as productName.Trim row.Product and save it as productName.On error
Change productName to blank.Change productName to blank.If productName is emptyIf productName is emptyYes
Show in the output: Skipped rowLabel: the Product column is empty.Show in the output: Skipped rowLabel: the Product column is empty.Add 1 to skippedRows.Add 1 to skippedRows.Skip to the next item.Skip to the next item.No
No steps
Make productName lowercase and save it as productKey.Make productName lowercase and save it as productKey.If alreadyPublished contains productKeyIf alreadyPublished contains productKeyYes
Add 1 to alreadyDoneRows.Add 1 to alreadyDoneRows.Skip to the next item.Skip to the next item.No
No steps
Set amountInSmallestUnit to 0.Set amountInSmallestUnit to 0.If a step below fails, save the error as priceErrorIf a step below fails, save the error as priceErrorTry
Round row.Price multiplied by 100 to the nearest integer and save it as amountInSmallestUnit.Round row.Price multiplied by 100 to the nearest integer and save it as amountInSmallestUnit.On error
Change amountInSmallestUnit to 0.Change amountInSmallestUnit to 0.If amountInSmallestUnit is less than or equal to 0If amountInSmallestUnit is less than or equal to 0Yes
Show in the output: Skipped rowLabel: the Price column must hold a number above 0, written as a plain figure like 49.99 with no currency symbol.Show in the output: Skipped rowLabel: the Price column must hold a number above 0, written as a plain figure like 49.99 with no currency symbol.Add 1 to skippedRows.Add 1 to skippedRows.Skip to the next item.Skip to the next item.No
No steps
If amountInSmallestUnit is greater than maxAmountInSmallestUnitIf amountInSmallestUnit is greater than maxAmountInSmallestUnitYes
Show in the output: Skipped rowLabel: the price is above the 'maxPricePerItem' ceiling of maxPricePerItem as text. Check it is not a typo, then raise the ceiling.Show in the output: Skipped rowLabel: the price is above the 'maxPricePerItem' ceiling of maxPricePerItem as text. Check it is not a typo, then raise the ceiling.Add 1 to skippedRows.Add 1 to skippedRows.Skip to the next item.Skip to the next item.No
No steps
Set stripeProductId to blank.Set stripeProductId to blank.Keep each item in productsAwaitingLink where item.name is productKey and save it as earlierProduct.Keep each item in productsAwaitingLink where item.name is productKey and save it as earlierProduct.If earlierProduct isn't emptyIf earlierProduct isn't emptyYes
Change stripeProductId to earlierProduct[0].id.Change stripeProductId to earlierProduct[0].id.No
If a step below fails, save the error as createProductErrorIf a step below fails, save the error as createProductErrorTry
Trim the id from the Stripe “Create a product” step and save it as stripeProductId.Trim the id from the Stripe “Create a product” step and save it as stripeProductId.On error
Show in the output: Skipped rowLabel: Stripe did not create a product for it. createProductError as text.Show in the output: Skipped rowLabel: Stripe did not create a product for it. createProductError as text.Add productName to the end of stripeFailures and save it as stripeFailures.Add productName to the end of stripeFailures and save it as stripeFailures.Skip to the next item.Skip to the next item.Add a record of name and id to the end of productsAwaitingLink and save it as productsAwaitingLink.Add a record of name and id to the end of productsAwaitingLink and save it as productsAwaitingLink.If a step below fails, save the error as rememberErrorIf a step below fails, save the error as rememberErrorTry
Set the stored value 'stripe_products_awaiting_link' to productsAwaitingLink.Set the stored value 'stripe_products_awaiting_link' to productsAwaitingLink.On error
Stop and report a problem: Stripe made the product '@productName' (stripeProductId) but the workflow could not note it down, so this run stopped before going further. If the next run makes a second product with this name, archive the extra one in Stripe. rememberError.message.Stop and report a problem: Stripe made the product '@productName' (stripeProductId) but the workflow could not note it down, so this run stopped before going further. If the next run makes a second product with this name, archive the extra one in Stripe. rememberError.message.Set stripePriceId to blank.Set stripePriceId to blank.If a step below fails, save the error as createPriceErrorIf a step below fails, save the error as createPriceErrorTry
Trim the id from the Stripe “Create a price” step and save it as stripePriceId.Trim the id from the Stripe “Create a price” step and save it as stripePriceId.On error
Show in the output: Skipped rowLabel: Stripe did not set a price on it. createPriceError as text.Show in the output: Skipped rowLabel: Stripe did not set a price on it. createPriceError as text.Add productName to the end of stripeFailures and save it as stripeFailures.Add productName to the end of stripeFailures and save it as stripeFailures.Skip to the next item.Skip to the next item.Set paymentLink to blank.Set paymentLink to blank.If a step below fails, save the error as createLinkErrorIf a step below fails, save the error as createLinkErrorTry
Trim the url from the Stripe “Create a payment link” step and save it as paymentLink.Trim the url from the Stripe “Create a payment link” step and save it as paymentLink.On error
Show in the output: Skipped rowLabel: Stripe did not return a payment link. createLinkError as text.Show in the output: Skipped rowLabel: Stripe did not return a payment link. createLinkError as text.Add productName to the end of stripeFailures and save it as stripeFailures.Add productName to the end of stripeFailures and save it as stripeFailures.Skip to the next item.Skip to the next item.
Set priceAsWritten to amountInSmallestUnit divided by 100.Set priceAsWritten to amountInSmallestUnit divided by 100.If a step below fails, save the error as logWriteErrorIf a step below fails, save the error as logWriteErrorTry
Google SheetsAdd a row to paymentLinksTabName in sheetUrl.Add a row to paymentLinksTabName in sheetUrl.On error
Stop and report a problem: A payment link was created for '@productName' but it could not be written to the '@paymentLinksTabName' tab, so this run has stopped rather than carry on unable to tell what it has already published. The link is paymentLink - paste it into that tab by hand, then run this again.Stop and report a problem: A payment link was created for '@productName' but it could not be written to the '@paymentLinksTabName' tab, so this run has stopped rather than carry on unable to tell what it has already published. The link is paymentLink - paste it into that tab by hand, then run this again.Add productKey to the end of alreadyPublished and save it as alreadyPublished.Add productKey to the end of alreadyPublished and save it as alreadyPublished.Keep each item in productsAwaitingLink where item.name is not productKey and save it as productsAwaitingLink.Keep each item in productsAwaitingLink where item.name is not productKey and save it as productsAwaitingLink.Add 1 to publishedThisRun.Add 1 to publishedThisRun.Show in the output: Published a payment link for '@productName': paymentLink.Show in the output: Published a payment link for '@productName': paymentLink.Set the stored value 'stripe_products_awaiting_link' to productsAwaitingLink.Set the stored value 'stripe_products_awaiting_link' to productsAwaitingLink.Set summary to Published publishedThisRun as text new payment link(s). Skipped skippedRows as text row(s). alreadyDoneRows as text product(s) already had a link.Set summary to Published publishedThisRun as text new payment link(s). Skipped skippedRows as text row(s). alreadyDoneRows as text product(s) already had a link.If publishedThisRun is greater than or equal to maxLinksThisRunIf publishedThisRun is greater than or equal to maxLinksThisRunYes
Change summary to summary This run stopped at the 'maxLinksThisRun' limit - raise it and run again to carry on down the list.Change summary to summary This run stopped at the 'maxLinksThisRun' limit - raise it and run again to carry on down the list.No
No steps
If stripeFailures isn't emptyIf stripeFailures isn't emptyYes
Join stripeFailures with , and save it as failedProducts.Join stripeFailures with , and save it as failedProducts.Stop and report a problem: summary Stripe failed for: failedProducts. Run it again to retry them; a product Stripe already made is reused, not made twice.Stop and report a problem: summary Stripe failed for: failedProducts. Run it again to retry them; a product Stripe already made is reused, not made twice.No
No steps
Finish the run: summary.Finish the run: summary.