Logo GoogleMailV2CLIAPI@2.5.1Logo CodeCLIAPI@1.0.1Logo GoogleSheetsV2CLIAPI@2.8.0Logo 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

Les entreprises, grandes et petites, font confiance

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

    • Logo Gmail
    • Logo 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