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

大小の企業から信頼されています

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 ロゴ
    • 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