The potential of carbon-based triphenylene-graphdiyne (tpGDY) and its derivatives for the electrochemical CO2 reduction reaction (eCO2R) was comprehensively explored using density functional theory (DFT) calculations. Six variants were studied: pristine tpGDY, tpGDY-BN, tpGDY-N01, tpGDY-N02, tpGDY-N08, and tpGDY-BN-B01. Pristine tpGDY, tpGDY-BN, and tpGDY-N08 exhibited exceptional catalytic activity, efficiently converting CO2 into CO and HCOOH without external energy input. Significantly, N-doped tpGDY catalysts incorporating sp2-hybridized nitrogen atoms at the acetylenic sites (tpGDY-N01 and tpGDY-BN-N01) demonstrated remarkable electrocatalytic activity for the targeted conversion of CO2 to CH3OH. This outstanding performance is further corroborated by the low limiting potentials of −0.18 V and −0.27 V for tpGDY-N01 and tpGDY-BN-N01, respectively, highlighting their economic viability. Furthermore, the feasibility of C2 production (e.g., C2H5OH, C2H4 and C2H6) through C–C coupling of *CHO+*CO intermediate was investigated for tpGDY-N01 and tpGDY-BN-N01. DFT calculations suggest these pathways are achievable but require potentials of 0.84 V and 0.71 V for tpGDY-N01 and tpGDY-BN-N01, respectively. This study demonstrates the efficacy of N-doped tpGDY as a metal-free electrocatalyst for CO2 reduction, enabling the generation of both C1 and C2 products. This discovery holds significant promise for the advancement of sustainable CO2 conversion technologies.