logotipo GoogleMailV2CLIAPI@2.5.1logotipo CodeCLIAPI@1.0.1logotipo GoogleSheetsV2CLIAPI@2.8.0logotipo GoogleSheetsV2CLIAPI@2.8.0

Write TCGPlayer sale notifications from Gmail to Google Sheets.

Write TCGPlayer sale notifications from Gmail to Google Sheets. You will need a spreadsheet with the following columns and formulas: Order Number Order Total Raw Timestamp Raw Matches Availability Date =IFERROR(DATEVALUE(SPLIT(C2, "+")), "") Total Qty =IF(NOT(ISBLANK(A2)),ARRAYFORMULA(SUM(VALUE(IFERROR(REGEXEXTRACT(I2:2, "\d+"), "")))), "") Category =IFS((B2-1.27)>=1, "Singles",(B2-1.27)>0, "Bulk",True, "") Beginning Card List -> =IF(NOT(ISBLANK(A2)),SPLIT(D2, ";"), "")

Jeffrey Starkecreated by Jeffrey Starke
How Zapier works (57 sec)
How Zapier works (57 sec)
Try this Zap FREE for 14 days

Confiável em empresas grandes e pequenas

This Zap works in 4 steps

  • 2 minutes to set up
  • Get back 1.2 hrs /week
  • 3 people use this zap

This Zap uses the following 3 apps

  • logotipo Gmail
  • logotipo Code by Zapier

More ways to use these popular apps!

Check out all the other ways you can connect Gmail and Code by Zapier,
Learn More