Google App Scripts Integration?

• Google Sheets API - creating app scripts or attaching them to a Spreadsheet that was created with API - Stack Overflow
• Method: projects.updateContent  |  Apps Script API  |  Google Developers

Images

• User who use subscription type can install helper GAS script
• GAS script use ClockTriggerBuilder and create new record from subscription item.

Require

• Implement GAS script
• Update scope

  philan.net/web/pages/api/auth/index.ts

  Lines 23 to 27 in 5aea108

  	scope: [
  	"https://www.googleapis.com/auth/drive.file", // require to create and edit sheet
  	"openid", // id_token
  	"profile" // aviator, default name, default id
  	],

  and privacy policy

Should subscription items be another sheet?
For example, the "Subscription" sheet.

I concern about how to stop subscriptions.

What "Interval" format is suitable?
https://docs.google.com/spreadsheets/d/152vYcYuz7JGcSWPwmzOQ-p2yvyJJxYOu3CvxFYbJu3w/edit?usp=sharing

It would be great to support for recurring donations.
But meantime, it would be nice adding a small feature to duplicate existing records.

If so, we can easily add our recurring donations by simply duplicating last month's records and just changing the date.

If so, we can easily add our recurring donations by simply duplicating last month's records and just changing the date.

Ah, It's reasonable.
I've created it as a new issue.
#19

I've implemented the clone feature in #20

Data Table image:

 [StartDate, EndDate, Every?, to, URL, amount, why?]

We need to define Every? format.
What format is suitable?

Probably, this lifecycle is バラバラ.

• 毎月 n 日
• nヶ月ごと
• n 日ごと

決済日はいつですか – Syncable

毎月1日が決済日となっています。

About billing for GitHub Sponsors - GitHub Docs
next billing date is different by user

よくある質問 | GiveOne

継続寄付は、お申し込み時点では決済されません。お申込みされてから直近の決済日（毎月10日、土日祝日にあたる場合は翌営業日）に決済されます。カード会社によって締め日・引き落とし日が違うので一概には言えませんが、決済日の翌月か翌々月にお引き落としがあります。

Probably, We would not need to get closing date strictly.

• every x year (create new record at XXXX-{StartDate's month}-01)
• every x month (create new record at XXXX-MM-{StartDate's day})
• every x days (create new record at XXXX-MM-DD)

is even enough?

• harrisiirak/cron-parser: Node.js library for parsing crontab instructions
• React Cron widget

cron format may be fit this case.

Different approach:

• Use cron and post /user/:user/subscription-check

• Cron Jobs - Vercel Documentation