image: img/spreadsheet-templates-email-marketing-tracker.jpg folder: marketing category: template

const config = {
    tabs: true,
    toolbar: true,
    worksheets: [{
            worksheetName: 'Campaign',
            worksheetId: 'campaigns',
            tabs: true,
            columns: [{
                    type: 'text',
                    title: 'Name',
                    width: '250px'
                },
                {
                    type: 'notes',
                    title: 'Description',
                    width: '400px'
                },
            ],
            data: [
                {
                    id: 1,
                    data: [
                        'Discounts of up to 20%',
                        'Our store is offering discounts of up to 20% on many of our products'
                    ]
                },
                {
                    id: 2,
                    data: [
                        'New products just arrived',
                        'New products are available in the store, come see'
                    ]
                },
                {
                    id: 3,
                    data: [
                        'Discount coupon',
                        'Present this coupon at one of our stores and enjoy a discount of up to 30% on different products'
                    ]
                },
                {
                    id: 4,
                    data: [
                        'Exclusive products with limited stock',
                        'A new line of exclusive products from our store is now available. These products have a limited stock that will not be replenished, so come guarantee yours before they run out.'
                    ]
                },
            ],
        },
        {
            worksheetName: 'People',
            worksheetId: 'peoples',
            columns: [{
                    type: 'text',
                    title: 'Name',
                    width: '200px'
                },
                {
                    type: 'email',
                    title: 'E-mail',
                    width: '200px'
                },
                {
                    type: 'dropdown',
                    title: 'Interests',
                    width: '200px',
                    source: ['Discounts', 'New products', 'Exclusive products'],
                    multiple: true,
                    options: {
                        newOptions: true
                    }
                },
            ],
            data: [
                {
                    id: 1,
                    data: [
                        'Magali Stracke',
                        'Magali.Stracke@gmail.com',
                        'Discounts'
                    ]
                },
                {
                    id: 2,
                    data: [
                        'Brionna Gusikowski',
                        'Brionna.Gusikowski@hotmail.com',
                        'New products'
                    ]
                },
                {
                    id: 3,
                    data: [
                        'Brock Breitenberg',
                        'Brock_Breitenberg@yahoo.com',
                        ''
                    ]
                },
                {
                    id: 4,
                    data: [
                        'Hans Smith',
                        'Hans_Smith49@hotmail.com',
                        'Discounts'
                    ]
                },
                {
                    id: 5,
                    data: [
                        'Benton Mueller',
                        'Benton.Mueller43@gmail.com',
                        'New products;Exclusive products'
                    ]
                },
                {
                    id: 6,
                    data: [
                        'Estevan Ullrich',
                        'Estevan_Ullrich13@gmail.com',
                        'Exclusive products'
                    ]
                },
            ]
        },
        {
            worksheetName: 'Prospection',
            columns: [{
                    type: 'record',
                    title: 'People',
                    worksheetId: 'peoples',
                    width: '200px',
                    source: []
                },
                {
                    type: 'record',
                    title: 'Campaign',
                    worksheetId: 'campaigns',
                    width: '200px',
                    source: []
                },
                {
                    type: 'calendar',
                    title: 'Send Date',
                    width: '130px'
                },
                {
                    type: 'dropdown',
                    title: 'Response',
                    width: '120px',
                    source: ['Positive', 'Negative'],
                },
            ],
            data: [
                [
                    '1',
                    '1',
                    '2018-06-10',
                    'Positive'
                ],
                [
                    '1',
                    '2',
                    '2018-07-30',
                    'Negative'
                ],
                [
                    '5',
                    '4',
                    '2018-07-02',
                    'Negative'
                ],
                [
                    '3',
                    '4',
                    '2018-07-02',
                    'Positive'
                ],
                [
                    '5',
                    '2',
                    '2018-07-16',
                    ''
                ],
                [
                    '4',
                    '3',
                    '2018-07-23',
                    'Negative'
                ],
            ],
        }
    ]
}