moshensky

<p>WordPress plugin that merge Contact form 7 functional with google spreadsheets (also works with private spreadsheet).</p>
<p>How to use:</p>
<p>Video instruction: <a href="https://www.youtube.com/watch?v=ZgZRBByY4fc" rel="nofollow ugc">https://www.youtube.com/watch?v=ZgZRBByY4fc</a><br />
Video instruction (OLD versions): <a href="https://www.youtube.com/watch?v=5ICWr5MMo7E" rel="nofollow ugc">https://www.youtube.com/watch?v=5ICWr5MMo7E</a></p>
<ol>
<li>Prepare API
<ul>
<li>Go to the <a href="https://console.developers.google.com/" rel="nofollow ugc">Console Developers API</a></li>
<li>Create new project (or choose existing one)</li>
<li>Click “enable API and services”, or click on “library” tab</li>
<li>Find in list “Google sheets API” and click “Enable”</li>
<li>Go to <code>Credentials</code> tab and click <code>create credentials</code>. In dropdown list choose <code>Service account key</code>. In next window select you service account, and <code>Key type</code> to <code>JSON</code>.</li>
<li>Save the JSON document</li>
<li>Upload JSON document on plugin page (second tab).</li>
</ul>
</li>
<li>Create a table
<ul>
<li>Go to the <a href="https://docs.google.com/spreadsheets/" rel="nofollow ugc">Google Spreadsheets</a> and create new table (or open exists table)</li>
<li>Copy table URL and ID. For example: <code>//docs.google.com/spreadsheets/d/1yhzO1Q6ikYysfg8LCHqegPM/edit#gid=0</code> in this table URL is: <code>1yhzO1Q6ikYysfg8LCHqegPM</code>, and ID is: <code>0</code>(parameter <code>gid</code>).</li>
<li>If you have private spreadsheet – you should grant edit rights to your service account (that we create earlier) directly in spreadsheet. You could find service account email in your website admin panel after uploading JSON file.</li>
</ul>
</li>
<li>Paste the spreadsheet URL and ID in plugin options page, upload JSON file, and choose other options.</li>
<li>Create usual form in <code>Contact form 7</code> and use it.</li>
</ol>


CF7 Spreadsheets

It works and also thanks for extra functions. Would be more good if you can reduce plugin size.

The most useful plugin in history.

Wordpress plugin that merge Contact form 7 functional with google spreadsheets (also works with private spreadsheet).

Gordon Guthrie

<h3>Insert spreadsheets into WordPress</h3>
<p>You can now easily insert <a title="insert google and excel compatible spreadsheets into WordPress" href="http://wordpress.vixo.com/publishing-figures-on-wordpress-with-a-vixo-spreadsheet/?from=wordpress.org&tab=description" rel="nofollow ugc">accounts and basic spreadsheets</a> directly into your WordPress site – when the user changes them they automatically update without need to be republished in any way.</p>
<h3>Charts and graphs in WordPress</h3>
<p>Simply drop <a title="graphs and charts in WordPress" href="http://wordpress.vixo.com/graphs-and-charts-in-wordpress/?from=wordpress.org&tab=description" rel="nofollow ugc">graphs and charts</a> into your WordPress blog. When the underlying data is edited the graph or chart automatically updates.</p>
<h3>Creating and inserting tables in WordPress</h3>
<p>Tabular data is very common. You can now easily <a title="create and insert tables into WordPress" href="http://wordpress.vixo.com/creating-and-inserting-tables-into-wordpress/?from=wordpress.org&tab=description" rel="nofollow ugc">create and insert tables of data</a> which the end user can sort or filter on your site.</p>
<h3>Embeddable forms for WordPress</h3>
<p>The Vixo spreadsheet lets you create <a href="http://wordpress.vixo.com/embeddable-vixo-forms/?from=wordpress.org&tab=description" rel="nofollow ugc">simple forms</a> that store information in an online spreadsheet and email you when someone submits data – making your life easier.</p>
<h3>Calculators and quotation engines for WordPress</h3>
<p>Specialist <a href="http://wordpress.vixo.com/building-a-calculator-or-quote-engine/?from=wordpress.org&tab=description" rel="nofollow ugc">quotation engines and calculators</a> are a cinch with Vixo – they can be built easily in a spreadsheet and then published into your blog.</p>
<h3>Using The Shortcode</h3>
<p>Because <a href="http://wordpress.vixo.com/embeddable-vixo-forms/?from=wordpress.org&tab=shortcode" rel="nofollow ugc">everything</a> in Vixo has a URL, The shortcode is very simple and has only  two forms:</p>
<pre><code>[vixo url="http://example.com/some/page"]

[vixo url="http://example.com/some/page", width="198px" height="100px"]
</code></pre>
<p>If it can the Vixo plugin will work out the size of the thing to be embedded automatically and resize to fit.</p>
<p>For a small number of cases (principally <a href="http://wordpress.vixo.com/inserting-spreadsheet-tables-into-wordpress/?from=wordpress.org&tab=shortcode" rel="nofollow ugc">inserting tables</a>) Vixo needs to be told how wide and high you want the embedded object to be. In this case use the long form and specify the width and height in pixels as per the example.</p>
<h3>Developers</h3>
<p>The plugin is hosted on <a href="https://github.com/hypernumbers/vixo-plugin" rel="nofollow ugc">Github</a>.</p>
<p>Feel free to post any problems on the <a href="https://github.com/hypernumbers/vixo-plugin/issues" rel="nofollow ugc">issues log</a></p>
<p>This readme was converted from WordPress markdown to GitHub markdown on http://wordpress-markdown-to-github-markdown.com/</p>
<h4>Tools</h4>
<p>Used <a href="http://wordpress-markdown-to-github-markdown.com/" rel="nofollow ugc">this web service</a> to synch the GitHub README.md with the WordPress readme.txt</p>


Embed charts graphs tables and forms with Vixo

Lets you embed graphs and graphs, tables, spreadsheets, forms and quotation engines from the Vixo online spreadsheet.

CF7 Spreadsheets vs Embed charts graphs tables and forms with Vixo