NotionCLIAPI@2.6.2 logoGoogleSheetsV2API logoZapierFormatterCLIAPI@1.0.4 logoGoogleSheetsV2API logoGoogleSheetsV2API logoNotionCLIAPI@2.6.2 logoNotionCLIAPI@2.6.2 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
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 Notion

  • Step 2 - Action

    Lookup spreadsheet row in Google Sheets

    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 Google Sheets

  • Step 5 - Action

    Lookup spreadsheet row in Google Sheets

  • Step 6 - Action

    Find database item in Notion

  • Step 7 - Action

    Update database item in Notion

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

    This Zap uses the following 3 apps

    • Notion logo
    • Google Sheets logo

    More ways to use these popular apps!

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