GoogleMailV2CLIAPI@2.0.2 logoCodeCLIAPI@1.0.1 logoGoogleSheetsV2CLIAPI@2.3.0 logoGoogleSheetsV2CLIAPI@2.3.0 logo

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

Trusted at companies large and small

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

    • Gmail logo
    • Code by Zapier logo

    More ways to use these popular apps!

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