Afiriito Pafomansu Dasshubodo: Notion to Sheets Tenpureto

Izumiru no fudo kurietaa wa maitsuki 4 jikan Stripe to thMenu afiriito paneru wo Excel ni kopii shite ita. Notion to Sheets tenpureto ni kirikaeta tokoro, kono jikan wa zero ni nari, sono jikan wa subete atarashii Reels seisaku ni mawatte iru.

Notion Homu

Jobu ni go-mai no shihyou kaado: gettsuji konbaajon, saikyou kontentsu sosu, genzai no tier (Bronze/Silver/Gold/Platinum), 30 nichi rifando, yosoku MRR. Subete Sheets no linked database kara yondemashita, shudo koshin nashi.

Sono shita ni futatsu no gyararii: "Top 10 Kontentsu 90 nichi" to "Mishigi Peiauto". Kouhakora wa supaadomin no kyu to dougi shi, shounin sareru to kaado wa jido de joutai ga kawaru.

Sheets Rou Detaa to Pibotto

"raw" tabu wa mainichi commission_id, restaurant_slug, plan_type, gross_amount, commission_amount, status, utm_source wo hozon. Apps Script ga maiyoru 04:00 ni thMenu CSV wo torimasu.

• Pibotto 1: Sosu x tsuki — donna chaneru ga kasegu ka
• Pibotto 2: Puran x joutai — rifando ritsu
• Pibotto 3: Resutoran x tsuki — chaaron sokei keikoku

Gemini Shukan Saumari

=GEMINI() shiki ga yomiyasui daijiesuto wo seisei: "12 kenkonba, 80 paasento ga TikTok, rifando 3.2 paasento, suikoku TikTok yosan kakudai". Maiyou getsuyou 09:00 ni webhook ga Notion ni okurimasu.

Kokai tenpureto rinku to shite kyouyu sureba ichi kurikku de fukusei, affiliate_id wo hari tsukereba go-fun de unyou kanou. Izumiru no kurietaa wa Discord de isshukan ni 80 fukusei wo kakuninshita.

FAQ

CSV wa shudo de hikidasu hitsuyou? Iie, Apps Script ga yoru ni thMenu afiriito API wo yobimasu.

Notion yuuryou puran wa hitsuyou? Free puran de jubun desu.

Gemini wa anzen? Resutoran mei wa hojo retsu de hasshu shite kara watashite kudasai.

お役に立ちましたか?シェアしてください。