import { GoogleSpreadsheet, GoogleSpreadsheetCell, GoogleSpreadsheetRow, GoogleSpreadsheetWorksheet, ServiceAccountCredentials, WorksheetGridRange } from 'google-spreadsheet';
import { BaseConnector, EventConfiguration, Reshuffle } from 'reshuffle-base-connector';
export interface GoogleSheetsConnectorConfigOptions {
    credentials: ServiceAccountCredentials;
    documentId?: string;
    sheetsId?: string;
}
export interface GoogleSheetsConnectorEventOptions {
    interval?: number;
    sheetIdOrTitle?: string;
    keyColumn?: string;
}
export interface ReshuffleGoogleSheetsCell {
    value: string | number | boolean;
    rowIndex: number;
    columnIndex: number;
    a1Row: number;
    a1Column: string;
    a1Address: string;
}
export declare class GoogleSheetsConnector extends BaseConnector<GoogleSheetsConnectorConfigOptions, GoogleSheetsConnectorEventOptions> {
    private readonly intervalIds;
    constructor(app: Reshuffle, configOptions?: GoogleSheetsConnectorConfigOptions, id?: string);
    onStart(): Promise<void>;
    onStop(): void;
    on(options: GoogleSheetsConnectorEventOptions, handler: any, eventId?: string): EventConfiguration;
    private getSpreadSheetDocument;
    getSheet(sheetIdOrTitle: number | string): Promise<GoogleSpreadsheetWorksheet | undefined>;
    getRows(sheetIdOrTitle: number | string): Promise<GoogleSpreadsheetRow[] | undefined>;
    getCell(sheetIdOrTitle: number | string, rowIndex: number, columnIndex: number): Promise<ReshuffleGoogleSheetsCell | undefined>;
    getCellByA1(sheetIdOrTitle: number | string, a1Address: string): Promise<ReshuffleGoogleSheetsCell | undefined>;
    getCells(sheetIdOrTitle: string | number, filters: WorksheetGridRange): Promise<Partial<GoogleSpreadsheetCell>[][] | undefined>;
    addRow(sheetIdOrTitle: string | number, values: {
        [header: string]: string | number | boolean;
    } | Array<string | number | boolean>, options?: {
        raw: boolean;
        insert: boolean;
    }): Promise<void>;
    private getInfo;
    private getStringifiedRowsFromWorksheet;
    onTimer(event: EventConfiguration): Promise<void>;
    sdk(): Promise<GoogleSpreadsheet | undefined>;
}