logotipo GoogleMailV2CLIAPI@2.5.2logotipo 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 …

  • Step 1 - Trigger

    Anytime a new email matching search is created in Your App

  • Step 2 - Action

    Run python in Code by Zapier

  • Step 3 - Action

    Lookup spreadsheet row in Google Sheets

  • Step 4 - Action

    Update spreadsheet row in Google Sheets

    • 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