Importing content with Google Sheets
we offer import via google sheets as a fast way to enter the large amount of film & event content that many festivals have note this option is most useful if you have a larger number of shows and showtimes to create if you only have a few, it will probably be easier and faster to create them manually via the admin we have articles describing how to do that listed here docid\ vanijyktjfek9nmavf35m to get started, copy our filmbot for festivals data entry template to your own google drive account copy the template https //docs google com/spreadsheets/d/18b1e8ttwzm df mm97pk7lypgvpdbsd2fbet 5hbjek/copy once you have made your own copy, you're ready to get started! here are the steps first, you'll need to set up a few items in your site that can't be created with the spreadsheet those are images docid\ hg 0x tydv9mfa3 thsj ticket type groups docid\ shpyb2ws6olsuqatxo6cu ticket types docid\ ephqhdyijc1kutye3kkmi venues docid\ yggtirqag711ajmaror2l sections docid\ mlwpr9d 40 yezdv5xe51 sponsor levels docid 8og4o1nmnhiahyuxlpmcv make sure you have added all your ticket types to an appropriate ticket type group, then move on to step 2 fill out your google sheet each column has a note attached to the column title that is visible when you hover on it you can reference these notes for instructions on how to fill out that column make your google sheet accessible to the filmbot for festivals application you can do this in one of 2 ways option 1 share the google sheet to anyone who has the link click the share button (top right) under the "get link" section, click "only people added can open with this link" change "restricted" to "anyone with the link" click done option 2 share the google sheet to the special email address for filmbot's google sheets integration click the share button (top right) in the "add people and groups" field, paste the following email address filmbot import\@filmbot import iam gserviceaccount com optionally change the permissions to "viewer" using the dropdown to the right of the field uncheck "notify people" and click "ok" click yes to any "share outside of organiation?" prompts that come up while you are viewing the google sheet, copy the url from the browser's location bar to your clipboard make sure the url starts with https //docs google com/spreadsheets/d/ from the dashboard, navigate to tools > import click "run importer" under google sheets paste the url to your google sheet into the field, and click continue carefully read through any errors or warnings you see on the screen, and fix any that need to be fixed if there are errors that cannot be ignored, fix them in your google sheet, and click try again if you have no errors that are required to be fixed, there will be a section called "what will be imported" and a "start import" button available click the button to import your content note that after every import, any showtimes you imported will be in "closed" sale status you will need to go to the scheduler and change them to sale status open