class Multiwoven::Integrations::Destination::GoogleSheets::Client

def build_catalog_from_spreadsheets(spreadsheet, connection_config)

dynamically builds catalog based on spreadsheet metadata
def build_catalog_from_spreadsheets(spreadsheet, connection_config)
  catalog = build_catalog(load_catalog)
  @spreadsheet_id = extract_spreadsheet_id(connection_config[:spreadsheet_link])
  spreadsheet.sheets.each do |sheet|
    process_sheet_for_catalog(sheet, catalog)
  end
  catalog
end