Scraping from Smartsheet and elsewhere

[antihippy_bardeen]

Hi There,

I am very new to Bardeen. Looking around I suspect my request may turn out to be niche (but I am hoping it is straightforward). I am a sports coach and I work with international athletes in the sport of fencing. Our governing body tends to share information in an excel-like interface which is ok to read but no ok to do anything interesting with. I am very bored of copying information from their tables into a calendar, or results into spreadsheets, by hand.

I have a couple of example of information I would like to extract where I am having real issues getting structured data.

Example 1.

Scrape this Selection Calendar into a specific Google calendar.

BF Epee Senior Mens Calendar - Smartsheet.com

First of all I can’t get my head around how I get the basic data out of this sheet. I have it active. I can add columns but nothing is being output anywhere.
Secondly how do I get Bardeen to intepret the columns represented by a checkbox or “start”? These could be useful as filters.

I have another table I would like to scrape into a Google sheet.

It’s this one:

britishfencing.com/wp-content/uploads/live-ranking/senior-mens-epee.html

I would like to filter for specific fencers but I also think I would like to perform a transform on it. if you look at the tournament results along the top there’s a lot of merged fields.

[ivan]

Hi @antihippy_bardeen

I apologize for the delay, we were on team offsite and some conversations slipped though the cracks.

Smartsheet to calendar

I ran a quick check and it seems possible to scrape smartsheet.

With a simple automation like this you can test if the dates are properly created on calendar.

Example link:

{{playbook_title}}

Things to consider:

• The events will be created from the Google Calendar of the account who integrated. There’s no way to “pick a calendar”
• The scraped dates are texts, so they will be interpreted by bardeen as dates, you need to test if if the output works as expected.

I would recommend having the dates formated with specific date and time. If you can do that from the smartsuite, better

Another possible approach:

1. Scrape to Google Sheets
2. From there you format the dates
3. You run an automation that “Gets table from google sheet” and creates the event based on that information.

Filtering based on conditionals

To answer to:

Secondly how do I get Bardeen to intepret the columns represented by a checkbox or “start”? These could be useful as filters.

The Bardeen scrape is able to pick up attributes from the page as well. It can pick up if that checkbox is empty (0) or full (1).

Example:

This way you can run conditionals with Bardeen to filter.

1. Scrape
2. When the scraped row = 1
3. Create calendar events

I have another table I would like to scrape into a Google sheet.

Seems possible to scrape as well, did you try it?

The same logic of using conditionals applies if you want to filter the results.

If it’s a very different case it might be better to create a different forum for it as well.