async def gsheet(self, ctx, url: str, *args):
"""Loads a character sheet from [GSheet v2.1](http://gsheet2.avrae.io) (auto) or [GSheet v1.4](http://gsheet.avrae.io) (manual), resetting all settings.
The sheet must be shared with Avrae for this to work.
Avrae's google account is `[email protected]`."""
loading = await ctx.send('Loading character data from Google... (This usually takes ~30 sec)')
try:
url = extract_gsheet_id_from_url(url)
except ExternalImportError:
return await loading.edit(content="This is not a Google Sheets link.")
override = await self._confirm_overwrite(ctx, f"google-{url}")
if not override: return await ctx.send("Character overwrite unconfirmed. Aborting.")
parser = GoogleSheet(url)
await self._load_sheet(ctx, parser, args, loading)
""" # noqa: E501
url = await self._check_url(ctx, url) # check for < >
# Sheets in order: DDB, Dicecloud, Gsheet
if beyond_match := DDB_URL_RE.match(url):
loading = await ctx.send('Loading character data from Beyond...')
prefix = 'beyond'
url = beyond_match.group(1)
parser = BeyondSheetParser(url)
elif dicecloud_match := DICECLOUD_URL_RE.match(url):
loading = await ctx.send('Loading character data from Dicecloud...')
url = dicecloud_match.group(1)
prefix = 'dicecloud'
parser = DicecloudParser(url)
else:
try:
url = extract_gsheet_id_from_url(url)
except ExternalImportError:
return await ctx.send("Sheet type did not match accepted formats.")
loading = await ctx.send('Loading character data from Google...')
prefix = 'google'
parser = GoogleSheet(url)
override = await self._confirm_overwrite(ctx, f"{prefix}-{url}")
if not override:
return await ctx.send("Character overwrite unconfirmed. Aborting.")
# Load the parsed sheet
character = await self._load_sheet(ctx, parser, args, loading)
if character and beyond_match:
await send_ddb_ctas(ctx, character)