NotionCLIAPI@2.19.0 logoGoogleSheetsV2API logoZapierFormatterCLIAPI@1.0.7 logoGoogleSheetsV2API logoGoogleSheetsV2API logoNotionCLIAPI@2.19.0 logoNotionCLIAPI@2.19.0 logo

Auto-Increment Table Row IDs on Notion

“When a new database row is created in your notion database, this zap injects a sequential, auto-incrementing ID number.”

C.J. Windischcreated by C.J. Windisch

This Zap uses a private app.

This means the developers of this app haven’t completed our full quality assurance steps. Zapier has limited details on this app and as a result can’t offer support for it. If you have questions about this app, please contact the person who gave you access to this Zap.
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 7 steps …

  • Step 1 - Trigger

    Anytime a new database item is created in Your App

  • Step 2 - Action

    Lookup spreadsheet row in Your App

    1 note from the creator …

    1. C.J. WindischC.J. Windisch (creator)This spreadsheet keeps track of the current id number. It needs to have the following header row: ["Text", "Number, "TicketNumber"] and the 2nd row should be: ["Ticket", "1", "PREFIX-1137"]. The "1" is whatever the starting number is - the Zap will updater this. And "PREFIX" is the prefix to put before the number for the ticket id such as "PROJ-255"
  • Step 3 - Action

    Format my data in Formatter by Zapier

  • Step 4 - Action

    Update spreadsheet row in Your App

  • Step 5 - Action

    Lookup spreadsheet row in Your App

  • Step 6 - Action

    Find database item in Your App

  • Step 7 - Action

    Update database item in Your App

    • 3.5 minutes to set up
    • Get back 1.2 hrs /week
    • 97 people use this zap

    This Zap uses the following 3 apps

    • Notion logo
    • Google Sheets (Deprecated) logo

    More ways to use these popular apps!

    Check out all the other ways you can connect Notion and Google Sheets (Deprecated).
    Learn More